Home > Vendors > oracle > d80170

D80170 - Oracle Database: Develop PL/SQL Program Units

This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers.

Learn To:

Create, and execute stored procedures and functions.
Design and use PL/SQL packages.
Create overloaded package subprograms for more flexibility.
Utilize Oracle-Supplied Packages in Application Development.
Create triggers to solve business challenges.
Build and execute SQL statements dynamically.

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:

Use conditional PL/SQL compilation and obfuscate (hide) code
Create triggers to solve business challenges
Manage dependencies between PL/SQL subprograms
Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
Use the compiler warnings infrastructure
Create, use, and debug stored procedures and functions
Design and use PL/SQL packages to group and contain related constructs
Create overloaded package subprograms for more flexibility
Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
Write dynamic SQL for more coding flexibility