Oracle Database 11g - Program with PL / SQL

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

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.

Audience

• Database Administrators
• Forms Developer
• PL/SQL Developer
• Portal Developer
• System Analysts
• Technical Consultant

Suggested Prerequisites

• Familiarity with data processing concepts and techniques
• Familiarity with programming languages

Course Objectives

• 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
• Use conditional PL/SQL compilation and obfuscate (hide) code

Send Inquiry