PL/SQL Video Tutorial For Beginners

PL/SQL basics

 
First, you need to learn the easiest things. This lesson is an introduction to PL/SQL language: you will create tables, insert data, write first blocks, declare variables and use them in code, learn loops and conditional instructions, etc.
 
 

Cursors

 
In this lesson, you will learn how to use PL/SQL cursors. A cursor is an object pointer to a private SQL area that stores information coming from a SELECT or data manipulation language query (INSERT, UPDATE, DELETE, or MERGE). A cursor holds the rows (one or more) returned by a SQL statement.
 
 

Procedures and Functions

 
In this lesson, you will learn the functions and procedures of PL/SQL language. The PL/SQL function is generally used to compute and return a single value. This returned value may be a single scalar value (such as a number, date or string) or a single collection (such as an array or nested table). Procedures resemble functions in that they are named program units that can be invoked repeatedly. The primary difference is that functions can be used in a SQL statement (for example in SELECT) whereas procedures cannot.
 
 

Exception

 
Exceptions are errors during code execution. In this lesson, you will learn how to handle errors.
 
 

Packages

 
In this lesson, you will learn about specific PL/SQL objects - packages. Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors.
 
 

Triggers

 
A trigger is like a stored procedure that Oracle invokes automatically whenever a specified event occurs. These few minutes will be devoted to triggers.
 
 

Dynamic SQL and Transactions

 
In this lesson, you will learn more about PL/SQL: Dynamic SQL and Transactions. These issues cause more difficulties for novice developers, so it's worthwhile to watch this lesson.
 
 

Collections and Object Types

 
Oracle Database allows you to create object-oriented programs. In this lesson, you will learn object types and collections.
 
 

BULK COLLECT

 
When you need to download a lot of data it is worthwhile to get interested in BULK COLLECT.
 
 

REF CURSOR and SYS_REFCURSOR

 
The last lesson of this course is devoted to specific PL/SQL objects: REF CURSOR and SYS_REFCURSOR.