Introduction to Oracle PL/SQL («ODSQL2»)

• What is PL/SQL and what is it used for?
• The structure of the PL/SQL block
• Variables, types and subtypes, PL/SQL data types
• RECORDS declaration and use
• Statements and comments
• Embedded SQL statements
• Explicit data type conversion
• Nested PL/SQL blocks
• CASE, SYS_CONTEXT
• Control statements – IF, ELSEIF and ELSE
• Rules for NULL, AND and OR
• Loops – LOOP, WHILE, FOR, EXIT and CONTINUE
• CURSOR implicit and explicit (static)
  • OPEN, FETCH, CLOSE
  • Cursor FOR loops
• Subroutines: Procedures and functions
• Autonomous transactions
• PL/SQL functions in SQL
• Exceptions – what to do in the event of an error
• Packages – basic concept
• Triggers

Theory and practical exercises

Good SQL knowledge and basic knowledge of the database is required.