28. ORACLE PL/SQL TOPICS

TOPICS

1. Introduction
2. Composite data types
1. %type attribute or anchor data types

                                         i.    %type

                                        ii.    %row type

User defined or temporary data types

                                       iii.    Record type or pl/sql record

                                      iv.    Index by table or pl/sql table or associate array

2. User defined or permanent data types

                                         i.    Objects

                                        ii.    Varrays

                                       iii.    Nested tables/ pl/sql table

3. Blocks
1. Unnamed or anonymous block
2. Named or stored procedures
3. Labeled blocks
4. Control statements or control structures
1. Sequential (default)
2. Conditional (if, case)
5. Cursors
1. Implicit
2. Explicit
3. Ref cursor
6. Exceptions (To handle run time errors)
1. predefine
2. user define
3. non predefine

7. stored procedure
1. procedures
2. functions
3. packages
4. triggers
8. pragmas
9. no copy
10. forward declaration
11. bulk collect & bulk bind
12. mutating triggers
13. dynamic sql (execute immediate)
14. table function
15. advanced topics