Workshop

ODSQL2

Introduction to Oracle PL/SQL («ODSQL2»)

In this workshop we teach you the basics of Oracle PL/SQL. Practical exercises will help you to write complex PL/SQL programs in a structured and efficient way.
Duration 5 days
Price 3'950.–
Register

Course facts

  • Understanding and being able to use the procedures, packages and functions of the Oracle database
  • 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.

Download

Download course details as PDF

Questions

Choose your date

Further courses