Once the statements are processed, the results are sent back and displayed on screen. These commands are then sent to the database for processing. SQL* Plus is an interactive tool that allows you to type SQL and PL/SQL statements at the command prompt. PL/SQL is not a standalone programming language it is a tool within the Oracle programming environment. In this chapter, we will discuss the Environment Setup of PL/SQL. PL/SQL provides support for developing Web Applications and Server Pages. PL/SQL provides support for Object-Oriented Programming. PL/SQL provides access to predefined SQL packages. PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types.Īpplications written in PL/SQL are fully portable. PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database. This reduces network traffic and provides high performance for the applications. PL/SQL allows sending an entire block of statements to the database at one time. In Dynamic SQL, SQL allows embedding DDL statements in PL/SQL blocks.

Static SQL supports DML operations and transaction control from PL/SQL block.

PL/SQL supports both static and dynamic SQL.

SQL is the standard database language and PL/SQL is strongly integrated with SQL. It supports the development of web applications and server pages.It supports object-oriented programming.It supports structured programming through functions and procedures.It offers a variety of programming structures.PL/SQL's general syntax is based on that of ADA and Pascal programming language.Īpart from Oracle, PL/SQL is available in TimesTen in-memory database and IBM DB2. PL/SQL can also directly be called from the command-line SQL*Plus interface.ĭirect call can also be made from external programming language calls to database. PL/SQL provides a built-in, interpreted and OS independent programming environment. PL/SQL is a completely portable, high-performance transaction-processing language. Following are certain notable facts about PL/SQL − The PL/SQL programming language was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL and the Oracle relational database.

Sql prompt input