Do you want to remove all your recent searches?

All recent searches will be deleted

Learn about Composite Variable in Oracle PL/SQL ...

6 years ago324 views

http://www.gogotraining.com, 1-877-546-4446
This video discusses:
•Create Composite Variables
•Assign and Update Values for Variables
•Reference PL/SQL Table Variables

This video is part of the Oracle 11g PL/SQL Programming Part 1 course which introduces you to PL/SQL and helps you understand the benefits of Oracle's proprietary database language. You will learn to create PL/SQL blocks of application code that can be shared by multiple users, forms, reports, and data management applications. In addition you will create anonymous PL/SQL blocks as well as named stored procedures, functions, packages and triggers. Also covered in this Oracle course is learning to develop, execute, and manage PL\SQL stored program units, subprograms, triggers, declaring identifiers and both user-defined and pre-defined exceptions. You will be introduced to the utilization of some of the more useful Oracle-supplied packages.

Course Prerequisites:
SQL and previous programming experience.

Course Objectives:
As a result of taking this Oracle PL/SQL training, you will be able to:
•Describe the features and syntax of PL/SQL
•Declare and use both scalar and complex datatypes
•Use PL/SQL constants and Boolean values
•Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
•Use CASE statement and expression
•Simple loop, While loop, For loop
•CONTINUE statement
•Handle runtime errors
•Use both pre-defined and user-defined exceptions
•Use the PRAGMA EXCEPTION_INIT clause
•Design and execute PL/SQL anonymous block
•Use the Oracle supplied PL/SQL packages to generate screen output

http://www.gogotraining.com, 1-877-546-4446