Online PL–SQL Training

  • 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