- Blocks
- Structure, Writing Anonymous Blocks
- Variables
- Oracle Data types, TYPE and ROWTYPE declarations, Value assignments
- Control structures
- IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition
- Cursors
- Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN
- Error Handling
- Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions
- Procedures
- Creating and Calling Procedures
- Functions
- Creating and Calling Functions
- Packages
- Package Header, Package Body
- Design Tips and Techniques
- Format of standard packages in an application, Spec and Body, NOCOPY hint theory
- Triggers
- Database triggers, CALLing procedures from triggers
- Dynamic SQL
- EXECUTE IMMEDIATE, DBMS_SQL package
- Oracle Supplied packages
- DBMS_OUTPUT, UTL_FILE
- Collection data types
- Associative Arrays, Nested tables, VARRAYs
Featured Courses