Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Concepts by Burleson Consulting

Oracle Database Program Constructs

This tutorial introduces the architecture of the PL/SQL language as describes how PL/SQL shares common language structure with other procedural languages. The use of PL/SQL as an internal Oracle language will also be introduced, and the use of interpreted and compiled PL/SQL will be discussed.

This tutorial begins with a discussion of PL/SQL encapsulation and shows anonymous code snippets, stored procedures, functions and packages.  The student will learn how to create and de-bug PL/SQL and how to use the SHOW ERRORS command to display PL/SQL parsing errors.  The student will also be exposed to run-time PL/SQL errors, and learn how to use the EXCEPTIONS clause to trap expected Oracle database errors.

The student will also see how to implement PL/SQL looping structures and see how to use PL/SQL to create FOR loops, WHILE loops and REPEAT-UNTIL loop structures. The student will also learn the DECLARE sections of PL/SQL and understand how to create program variables and array variables.  The student will also learn how to assign Oracle database values to variables.

This tutorial is heavy or reading, but it is necessary for you to get the overall concepts before we start coding PL/SQL programs.

Special Note:

The next three tutorials will focus on PL/SQL coding, and the use of PL/SQL to solve business problems.  To get the most from your readings, you are highly encouraged to work-along with the Feuerstein book, writing PL/SQL snippets.  The best way to learn any computer language is to use it, and the more hands-on practice you get, the better you will internalize the concepts.

I like to use the analogy of a swimming class. You can attend lectures on swimming, but you learn to swim by diving into the pool.  So, let’s dive into the pool and start coding with PL/SQL.

Learning Outcomes

Upon completion of this tutorial, you will be able to:

* Learn basic PL/SQL structure

* Describe Boolean logic in PL/SQL

* Declare and use program variables

* Define and use cursors

* Use looping constructs in PL/SQL

* Perform assignment statements in PL/SQL

For more details, see the "Easy Oracle Series" a set of books especially designed by Oracle experts to get you started fast with Oracle database technology.

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.