PL/SQL
This is a collection of basic information about Using Oracle PL/SQL. The best way to learn PL/SQL is to either read the Oracle Documentation or buy(and read) books on the subject. ‘Practise’ has not stopped making a man perfect.
Basic Structure of PL/SQL
PL/SQL stands for “Procedural Language extension to the SQL”. SQL is the most common and most popular way of querying of relational databases. It extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other. Each block performs a logical action in he program.
The following are a few defining characteristics of the language.
- Structured, Readable
- High Performance, Highly Integrated
- Embeded (Inside Oracle Environment.)
- Accessible, Standard, and Portable (for oracle development)
- One that I really like is “It’s Easy”
A PL/SQL block of code has the following features:
DECLARE
/* Declarative section: variables, types, and local subprograms. */
BEGIN
/* Executable section: procedural and SQL statements go here. */
/* This is the only section of the block that is required. */
EXCEPTION
/* Exception handling section: error handling statements go here. */
END;
TO BE CONTINUED…
This entry was posted on Monday, January 8th, 2007 at 3:14 pm and is filed under HowTo. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.