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
- 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.
- Manage PL/SQL subprograms and triggers.
- Understand and influence the PL/SQL compiler.
- Manage dependencies.
Benefits to You
Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. In this course, students learn and use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts.
- PL/SQL Developer
- Database Administrators
- System Analysts
- Forms Developer
- Technical Consultant
- Portal Developer
- 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