This tutorial teaches the basics of programming in PL/SQL with examples. Use this tutorial as your guide or reference while programming with PL SQL. The programming concepts discussed in this tutorial is specific to Oracle PL SQL. The concepts like cursors, functions and stored procedures can be used in other database systems also with some changes in syntax.
The concepts like cursors, functions and stored procedures can be used in other database systems also with some changes in syntax.
Introduction to PL/SQL
Advantages of PL/SQL
A Simple PL/SQL Block
Scope of variables
Conditional Statements in PL/SQL
Iterative Statements:Simple Loop
Iterative Statements : While Loop
Iterative Statements: For Loop
Passing Values To and From a Record
PL/SQL : Cursors
PLSQL: Implicit Cursor
Explicit Cursor - Simple Loop
Explicit Cursor : while loop
Explicit Cursor : for loop
click here to Post your comments and suggestions regarding this page.