PL/SQL for Not Yet Techies

"Computer Careers: Working With Oracle's Procedural Programming Language Combined With SQL for Accessing Databases"

by Richard Stooker, President Info Ring Press and author of Secrets of Changing to a Computer Career

PL/SQL is Oracle's Procedural Language extension to SQL. Its syntax, structure and data types are similar to ADA. PL/SQL includes object oriented programming techniques such as encapsulation, function overloading and information hiding.

Oracle's purpose in creating PL/SQL was to combine a database language and procedural programming language. It is commonly used to write data-centric programs to manipulate data in an Oracle database.

The basic unit of PL/SQL is called a block

A block is made up of three parts:

Declarative
Executable
Exception-building

Oracle databases support two procedural languages -- PL/SQL and Java.

The blocks can be compiled once and stored in executable form, therefore increasing speed and efficiency. A program stored in a database in this compiled form is called a stored procedure. They can be started up by a trigger command.

The primary strength of PL/SQL is in providing a server-side, stored procedural language that is easy-to-use, seamless with SQL, robust, portable, and secure. It needs no explicit installation or licensing because it is an implicit part of the Oracle9i Database. The compiler and interpreter are also embedded in Oracle Developer.

Next: Rational Rose

Use Your New Computer Career as a Stepping Stone to Even Greater Success

Send off for your free 7-part Techie Plus eCourse now. So that you can learn:

The 7 most important skills to even greater business achievement -- not to mention wealth and (maybe) fame
Why techies are expendable in bad times and how to protect yourself from them
Why the world's richest computer programmer has not written any code in ages
How one ex-engineer now makes $500,000 a year
The abilities most techies don't even realize they don't have -- which confines their success to their technical abilities
Why techies are expendable in bad times and how to protect yourself from them

It's fast and easy. You will receive the first part in your email box within minutes.

I respect your privacy. I will never sell, rent or trade your email address.

After you subscribe, the form will redirect you to a thank you page.

Thank you!

Rick Stooker

Permission is granted to reprint the above article in an ezine or on a website as long as it is reprinted in full, with no changes, with full credit and with this contact information and link included at the bottom. All other rights reserved.

Computer Careers (Home) Sitemap Contact Privacy

Info Ring Press

Richard Stooker

PO Box 617

130-G Ballwin Manor Dr

Ballwin, MO 63011

(636) 394-2052

rick@inforingpress.com