Conditionally control code flow (loops, control structures). Create stored procedures and functions. Use PL/SQL packages to group and contain related constructs. Create triggers to solve business challenges. Use some of the Oracle supplied PL/SQL packages to generate screenoutput and file output. Create custom packages for applications. Write Dynamic SQL code for applications.
Benefits to You:
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and delivera higher quality of service by enabling consolidation onto database clouds.
Use Oracle SQL Developer
You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optionaltools.
Course Bundle Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database:Develop PL/SQL Program Units courses.