This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by the multiple forms, reports and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Students learn to develop, execute, and manage PL/SQL stored programs units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
TO be more effective Oracle developer, we recommend basic knowledge of Oracle Development.