1. 1.PL/SQL Concepts
2. 2.General Programming Languagae Fundas
3. 3.SQL in PL/SQL
4. 4.Control Structures
   1. Conditional control
      1. IF Statement
         1. IF-THEN
            1. Example
         2. IT-THEN-ELSE
            1. Example
         3. NULL Condition
            1. Example
         4. ELSIF Statement
            1. Example
         5. Nested IF Statement
            1. Example
      2. CASE
         1. CASE Statement
            1. Example
         2. SEARCHED CASE Statement
            1. Example
         3. CASE Expressions
            1. Example
      3. NULLIF Function
         1. Example
      4. COALESCE Function
         1. Example
   2. Iterative Control
      1. Simple Loops
         1. EXIT STATEMENT
            1. Example
         2. EXIT WHEN STATEMENT
            1. Example
      2. WHILE Loops
         1. Example
      3. Numeric FOR Loops with the IN(REVERSE) Option
         1. Example
      4. CONTINUE
         1. CONTINUE Statement
            1. Example
         2. CONTINUE WHEN Condition
            1. Example
      5. Nested Loops
         1. Example
      6. RETURN
         1. Example
5. 5.PL/SQL BLOCKS
6. 6.Exception Handling
   1. Built-in Exceptions
      1. ACCESS_INTO_NULL-6530
      2. CASE_NOT_FOUND-6592
      3. COLLECTION_IS_NULL-6531
      4. CURSOR_ALREADY_OPEN-6511
      5. DUP_VAL_ON_INDEX-1
      6. INVALID_CURSOR-1001
      7. INVALID_NUMBER-1722
      8. LOGIN_DENIED-1017
      9. NO_DATA_FOUND+100
      10. NO_DATA_NEEDED-6548
      11. NOT_LOGGED_ON-1012
      12. PROGRAM_ERROR-6501
      13. ROWTYPE_MISMATCH-6504
      14. SELF_IS_NULL-30625
      15. STORAGE_ERROR-6500
      16. SUBSCRIPT_BEYOND_COUNT-6533
      17. SUBSCRIPT_OUTSIDE_LIMIT-6532
      18. SYS_INVALID_ROWID-1410
      19. TIMEOUT_ON_RESOURCE-51
      20. TOO_MANY_ROWS-1422
      21. VALUE_ERROR-6502
      22. ZERO_DIVIDE-1476
   2. User-Defined Exceptions
7. 7.CURSORS
   1. Implicit CURSORS
   2. Explicit CURSORS
      1. Declaring the Cursor
         1. CURSOR c_cursor_name IS select statement
         2. RECORD TYPE
            1. Table-based
            2. record_name table_name%ROWTYPE
            3. Cursor-based
            4. record_name cursor_name%ROWTYPE
            5. Programmer-defined
      2. Opening the Cursor
         1. OPEN cursor_name
      3. Fetching the Cursor
         1. FETCH cursor_name INTO PL/SQL variables;
         2. FETCH cursor_name INTO PL/SQL records;
      4. Closing the Cursor
         1. CLOSE cursor_name;
      5. CURSOR Attributes
         1. %NOTFOUND
            1. cursor_name%NOTFOUND
         2. %FOUND
            1. cursor_name%FOUND
         3. %ROWCOUNT
            1. cursor_name%ROWCOUNT
         4. %ISOPEN
            1. cursor_name%ISOPEN
      6. CURSOR FOR Loop
      7. NESTED CURSOR
      8. parameters in a CURSOR
      9. complex nested CURSORS
      10. FOR UPDATE CURSOR
      11. WHERE CURRENT CURSOR
   3. REF CURSOR
8. 8.TRIGGERS
   1. DML Triggers
      1. Statement Level Triggers
      2. Row Level Triggers
      3. syntax
         1. Trigger event
         2. Trigger level
         3. Trigger Restriction
         4. Trigger action
   2. DDL Triggers
   3. DB Tiggers
9. 9.COLLECTIONS
   1. RECORDS
      1. Table Based RECORDS
      2. Cursor Based RECORDS
      3. Programmer Based RECORDS
      4. Nested RECORDS
      5. Collecion Of RECORDS
   2. PL/SQL TABLES
   3. NESTED TABLES
   4. VARRAYS
   5. MULTILEVEL COLLECTIONS
10. 10.PROCEDURES
11. 11.FUNCTIONS
12. 12.PACKAGES