Vi ste ovdje
Overview/Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
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 paths.
Expected Duration (hours)
1.9...
Overview/Description
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.
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 paths.
Expected Duration (hours)
1.7
Lesson ObjectivesOracle Database...
Overview/Description
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
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 paths.
Expected Duration (hours)
1.3
Lesson ObjectivesOracle Database 11g:...
Overview/Description
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.
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 paths.
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 11g:...