PL/SQL BASICS

• SQL and PL/SQL
• PL/SQL anonymous block structure and Datatypes
• Variable declarations and naming conventions
• Object naming rules
• Executable Statements
• Operators in PL/SQL
• Conditional control / Repetition control
• LOOP statements ? Basic LOOP, WHILE, FOR
• CASE Expressions and Statements
• Nested Blocks
• Labels and block identification
• Basic Coding Standards
• SQL*PLUS development environment
• Using SQL Developer
• Bind variables / Substitution variables
• Datatypes: Scalar, Collection, Record, Reference
• Commenting code

WORKING WITH DATABASE DATA

• SELECT statements in PL/SQL
• Selecting single and multiple rows
• Referencing other variables or a database column?s datatypes with %TYPE
• Using %ROWTYPE
• Using sequences in PL/SQL
• Modifying database data (DML)
• Transaction control commands
• Selecting data into PL/SQL variables
• Explicit cursors / Cursor attributes
• Transaction control commands
• Referencing other structures datatypes
• Using the cursor FOR LOOP
• FOR UPDATE / WHERE CURRENT OF

EXCEPTION HANDLING

• Writing an exception handler section
• Handling predefined and user-defined exceptions
• Controlling exception processing
• Preventing unhandled exceptions
• RAISE_APPLICATION_ERROR
• Using SQLCODE and SQLERRM

STORED PL/SQL OBJECTS

• Introduction to procedures and functions stored in the database
• Creating stored PL/SQL objects
• Passing values with parameters
• Creating procedures, functions, packages, package bodies in SQL*Plus and SQL Developer
• Introduction to database triggers
• Viewing and recompiling stored code