Oracle PL/SQL
Course
In Bristol, Manchester, Birmingham and 3 other venues
Description
-
Type
Course
-
Location
This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Reviews
Subjects
- PL/SQL
- SQL
- IT
Course programme
- What is PL/SQL?
- Basic Elements
- Variables and Constants
- Data Types
- Initialising Variables and Assigning Values
- Using SQL Statements in Code
- Generating Output to SQL or SQL Developer
- IF THEN ELSIF ELSE Statements
- CASE Statements
- The Basic Loop Construct
- WHILE and FOR Loops
- Nested and Labeled Loops
- The GOTO Statement
- The CONTINUE Statement
- What is a Cursor?
- Implicit and Explicit Cursors
- Cursor Operations
- Declaring, Opening and Closing Cursors
- Fetching Rows
- Status Checking
- Using Cursors FOR UPDATE
- The Cursor FOR Loop
- Parameterised Cursors
- The EXCEPTION Section
- Types of Exception
- Handling Named System-Raised Exceptions
- Handling Un-named System-Raised Exceptions
- User-Declared Exceptions and Application Errors
- WHEN OTHERS THEN NULL
- Nested and Labelled Blocks
- Propagation of Exceptions
- Scope of Variables and Cursors
- Scope of Goto Statements
- Declaring Record Types
- Handling PL/SQL Records
- Nested Records
- Declaring PL/SQL Index-By Tables or Associative Arrays
- PL/SQL Table Built-in Functions
- Manipulating PL/SQL Tables or Associative Arrays
Oracle PL/SQL