Login

Username:

Password: 

Join us Now |  Forgot Password? | Forgot UserName?

PL/SQL

Learn step by step



What is PL/SQL?

PL/SQL is Oracle’s procedural language extension to SQL. PL/SQL permit we to mix SQL statements with procedural statements as e.g. IF statement, Looping structures and many more. SQL superset is PL/SQL. It uses SQL for data received and implementation and uses its individual statements for data action.

PL/SQL categorized into two types as follows:

  • Anonymous blocks
  • Stored procedures
Anonymous block

Anonymous block is a PL/SQL block that display within our application. Many of applications PL/SQL blocks can display where SQL statements can display.This types of blocks are called as Anonymous blocks.

Stored Procedure

Stored Procedure is a PL/SQL block that is saved in the database with a name. Application programs can perform these procedures using the name. Oracle also permission you to make functions, which are like as procedures but return a value, and packages, which are a gathering of procedures and functions.

PL/SQL Engine

Every PL/SQL block is initially executed by PL/SQL engine.PL/SQL Engine that perform compiles and executes PL/SQL blocks. PL/SQL engine is accessible in Oracle Server and explicit Oracle tools such as Oracle Reports and Oracle Forms.

PL/SQL engine perform all procedural statements of a PL/SQL of the block, but forward SQL command to SQL statements render in the Oracle RDBMS. That means PL/SQL divides SQL commands from PL/SQL commands and executes PL/SQL instruction using Procedural statement executor, which is a part of PL/SQL engine.

PL/SQL Architecture

The PL/SQL language is really build up of two different languages. Procedural code is processing by the PL/SQL engine, while SQL is forward to the SQL statement render. PL/SQL Architecture

For the almost all part, the hard binding between these two languages create PL/SQL display like a single language to almost all developers.



Related Videos