Basics of PL/SQL


PL/SQL stands for Procedural Language extension of SQL.

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL.

PL/SQL Environment
PL/SQL is not an Oracle product in its own right; it is a technology used by the Oracle server and by certain Oracle tools. Blocks of PL/SQL are passed to and processed by a PL/SQL engine, which may reside within the tool or within the Oracle server. The engine that is used depends on where the PL/SQL block is being invoked from. When you submit PL/SQL blocks from a Oracle precompiler such as Pro*C or Pro*Cobol program, userexit, iSQL*Plus, or Server Manager, the PL/SQL engine in the Oracle Server processes them. It separates the SQL statements and sends them individually to the SQL statements executor.

A single transfer is required to send the block from the application to the Oracle Server, thus improving performance, especially in a client-server network. PL/SQL code can also be stored in the Oracle Server as subprograms that can be referenced by any number of applications connected to the database. 

Many Oracle tools, including Oracle Developer, have their own PL/SQL engine, which is independent of the engine present in the Oracle Server. The engine filters out SQL statements and sends them individually to the SQL statement executor in the Oracle server. It processes the remaining procedural statements in the procedural statement executor, which is in the PL/SQL engine. The procedural statement executor processes data that is local to the application (that is, data already
inside the client environment, rather than in the database). This reduces the work that is sent to the Oracle server and the number of memory cursors that are required.

Advantages of PL/SQL
These are the advantages of PL/SQL.
Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or a logical module. PL/SQL Blocks can be stored in the database and reused.
Procedural Language Capability: PL SQL consists of procedural language constructs such as conditional statements (if else statements) and loops like (FOR loops).
Better Performance: PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.
Error Handling: PL/SQL handles errors or exceptions effectively during the execution of a PL/SQL program. Once an exception is caught, specific actions can be taken depending upon the type of the exception or it can be displayed to the user with a message.

The PL/SQL language is a robust tool with many options. PL/SQL lets you write code once and deploy it in the database nearest the data. PL/SQL can simplify application development, optimize execution, and improve resource utilization in the database.

The language is a case-insensitive programming language, like SQL. This has led to numerous formatting best practice directions. Rather than repeat those arguments for one style or another, it seems best to recommend you find a style consistent with your organization’s standards and consistently apply it. The PL/SQL code in this book uses uppercase for command words and lowercase for variables, column names, and stored program calls

PL/SQL also supports building SQL statements at run time. Run-time SQL statements are dynamic SQL. You can use two approaches for dynamic SQL: one is Native Dynamic SQL (NDS) and the other is the DBMS_SQL package. The Oracle 11g Database delivers new NDS features and improves execution speed. With this release, you only need to use the DBMS_SQL package when you don’t know the number of columns that your dynamic SQL call requires. Chapter 11 demonstrates dynamic SQL and covers both NDS and the DBMS_SQL package.


Sat, 10/24/2015 - 10:43 Writing is a form of communication that requires absolute precision. We can create your custom writing paper as little as 48 hours on any subject.
write my paper not plagiarized 90f78ftyetws He even recognized his.
free accounting homework help We’ve covered all the prompts.

Thu, 04/05/2018 - 23:52

А именно в этом доме Эрик любил закатывать различные вечеринки. А именно это главная задача этого сайта.
Заходите и смотрите или качайте лучшие фильмы и сериалы у нас на сайте скачать бесплатно фильмы на телефон

Tue, 04/17/2018 - 15:34

cialis generico lilly
cialis great britain
where to buy viagra in stores
Viagra vs viagra vs levitra

Sun, 04/22/2018 - 02:22

If you search to see some of the finest and really exclusive free xxx porn videos with simple click, then you have to visit tube porn stars portal. Here at massage porn tube you will find dirty free porn videos online and thousands of sexy porn stars, all available and always on duty for the best porn action.

Sun, 04/22/2018 - 05:30

Tune in for some of the most rated and most needed sex videos online by simply surfing [url=][/url], the number one place where you can watch any style of pokemon porn videos your mind desires in seconds. The awesome porn stars, the finest moms and many more, all available to rock your sexual dreams with mind blowing x videos porn. Only most rated adult content in HD image and with the best options you can get, all for free at [url=][/url], the only place to perform your dreams in proper modes.

Sun, 04/22/2018 - 12:25

Tune in for some of the hottest and most wanted porn videos online by simply browsing [url=][/url], the number one place where you can find any kind of extreme porn videos your mind desires in seconds. The stunning porn stars, the finest moms and many more, all available to rock your sexual fantasy with mind blowing top porn videos. Only hottest adult content in HD image and with the best options you can get, all for free at [url=][/url], the only place to carry out your fancy in proper modes.

Mon, 04/23/2018 - 02:32

If you prefer to watch some of the most rated and highly exclusive amateur porn videos with simple click, then you should visit [url=][/url] pregnant porn tube portal. Here at [url=][/url] indian porn tube you will get nasty free sex videos online and tons of horny porn stars, all available and always on duty for the best porn experience.

Thu, 04/26/2018 - 00:20

Три дня назад изучал контент сети, и неожиданно к своему удивлению обнаружил поучительный вебсайт. Смотрите: [url=]Ремонт Apple Воронеж Сервисный центр[/url] . Для меня вышеуказанный ресурс произвел хорошее впечатление. Удачи!

Thu, 04/26/2018 - 02:18

[url=]ab gymnic официальный сайт[/url] abgymnic режимы

Thu, 04/26/2018 - 16:36

Ночью мониторил содержание сети, неожиданно к своему восторгу увидел поучительный сайт. Посмотрите: [url=][/url] . Для моих близких данный веб-сайт показался довольно нужным. Хорошего дня!

Post new comment

The content of this field is kept private and will not be shown publicly.
All Rights Reserved. Copyright 2008-11