PL/SQL Notes

Some of my notes and preparation for the Oracle PL/SQL Exam 1Z0-149.

Topics

1. Declaring PL/SQL Variables
2. Writing Executable Statements
3. Writing SQL in PL/SQL
4. Writing Control Structures
5. Working with Composite Data Types
6. Using Explicit Cursors
7. Handling Exceptions
8. Using PL/SQL Subprograms
9. Creating Procedures and Using Parameters
10. Creating Functions
11. Creating Packages
12. Working with Packages
13. Using Dynamic SQL
14. Design Considerations for PL/SQL Code
15. Creating Compound, DDL, and Event Database Triggers
16. Using the PL/SQL Compiler
17. Managing PL/SQL Code
18. Managing Dependencies

Reference

Reference List

Exercises

Practice exercises from the following books:

• Leerboek Oracle PL/SQL by Gilbert Rattink