Oracle Database 11g PL SQL Variables Attributes and Executable Statements

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.

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.

Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

WEB

Using PL/SQL Development Environments| - recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.|Introducing PL/SQL| - identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.|Introducing PL/SQL Variables| - identify the steps for declaring and initializing PL/SQL variables.|Introducing PL/SQL Data Types and Attributes| - identify the uses of different PL/SQL data types, the TYPE attribute, and BIND variables.|Writing Executable Statements| - identify the steps for constructing executable statements using various PL/SQL block elements.|Working with Executable Statements| - evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...