PL/SQL Workshop

Introduction

• A short introduction into SQL and PL/SQL

Database objects:

• A short overview of database objects (table, view, type, sequence, trigger, package, function, procedure, synonym)
• An in-depth overview of objects (type)
• Naming convention

Data types:

• Varchar2, number, date…
• Records, Collections…
• BLOB, XML, CLOB, LONG, RAW…
• Naming conventions

Flow control (if, case)

Interactive control (loop, for-loop, while)

Cursors and cursor for-loops

Transactions:

• DML into PL/SQL
• Commit, rollback
• Autonomous transactions

Exceptions & exception management

• Custom exceptions
• Sqlcode, sqlerrm, dbms_utility.format_error…
• Naming conventions

Conditional compilation

Triggers

Procedures & functions

Packages:

• Using variables
• Declaration
• Naming conventions

Dynamic SQL:

• DDL in PL/SQL
• DML in dynamic SQL
• SQL injection

Programming tools:

• SQLDeveloper
• PLSQL Developer
• TOAD

For all inquiries regarding education, please contact us at learn@croz.net.

Check course dates.