Using PL SQL with an Oracle Server

To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block

Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Database administrators, application developers, and database operators

WEB

Block statements| - write lexical units in their correct format in a PL/SQL block.|Data conversion| - perform data conversion in PL/SQL.|Nested blocks| - use qualifiers to access and evaluate variables in PL/SQL blocks.|Using block statements| - convert and evaluate variables in PL/SQL.|SELECT statements in PL/SQL| - use a SELECT statement in a PL/SQL block to retrieve data from a database.|DML commands and cursor attributes| - use implicit SQL cursor attributes to determine the outcome of DML commands.|Using and evaluating SQL commands in PL/SQL| - use PL/SQL to perform database operations and use SQL cursor attributes to evaluate results.|

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 -...