SQl DML COMMANDS |
---|
Basic Select Statement |
Restricting & Sorting Data |
Single Row Functions |
Joins |
Group & Having Clause |
Sub-query |
Insert, Update, Delete |
Commit, Rollback |
DDL COMMANDS |
Creating & Managing Tables |
Various Constraints / Keys |
Views and Other Objects |
DCL COMMANDS |
---|
Controlling User Access |
ADVANCE SQL CONCEPTS |
PL / SQL |
PL / SQL Environments |
Declaring Variables |
Block Structures |
Block Types |
%TYPE Attribute |
Executable Statements |
Cursor |
Procedures & Functions |
Packages |
Triggers |