Oracle Tutorials PL/SQL Programming
| 
| 
Watch Video Tutorials on PL/SQL programming.
PLSQL stands for Progamming Language extension to SQL. PL/SQL is Oracle Corporation's proprietary programming language. It is a versatible, robust language that is used in most of the Oracle products. PL/SQL has a block structure with a definite syntax. In this section, we have presented a series of tasks to be performed using PL/SQL based on our Motion Picture database (For more information see our SQL section).
It is recommended that you download the script and execute it on the machine. The structure and data in the tables has also been provided. Please review the structure and data in detail as it is very important to understand the data before you can use it.
As we have mentioned earlier, your best resource is the Oracle Documentation. We hope you enjoy working on these tasks.
We recommend that you have Oracle installed, and that you execute the script mentioned below to create the tables.
The Motion Picture database consists of the following tables:
MOVIE - details about movies
COMPOSER - details about musicians who have composed the music for the movie
DIRECTOR - details about directors
DIRECTOR_MOVIES - details about the director and the movies
CAST - details of the cast (actors)
MOVIE_CAST - details of the cast and the movie they acted in
-------------------------------------------------------------------------------------------------
Username for Motion Picture Database : MV1
Password for Motion Picture Database : MV1
Tasks based on PL/SQL : (Learn By Doing !)
1. Variable declaration and displaying variables
2. SQL Statements in PL/SQL programs
3. PL/SQL Constructs
* IF statements
* LOOP statements
4. Cursors in PL/SQL
5. Exception Section
