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.
Topics:
Introduction to PL/SQL
Advantages of PL/SQL
A Simple PL/SQL Block
PL/SQL Placeholders
PL/SQL Variables
Scope of variables
PL/SQL Constants
Conditional Statements in PL/SQL
Iterative Statements:Simple Loop
Iterative Statements : While Loop
Iterative Statements: For Loop
PL/SQL Records
PL/SQL Records:Rowtype
Passing Values To and From a Record
PL/SQL : Cursors
PLSQL: Implicit Cursor
PLSQL:Explicit Cursors
Explicit Cursor - Simple Loop
Explicit Cursor : while loop
Explicit Cursor : for loop
comments
click here to Post your comments and suggestions regarding this page.
