Vi ste ovdje
Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Expected Duration (hours)
1.3
Lesson ObjectivesOracle Database 11g: Managing PL/SQL Code and Dependencies...
Overview/Description
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 11g:...
Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 11g: Subprograms, Packages...
Overview/Description
To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.
Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 11g:...