PL/SQL - SPLessons

Chapter 1

PL/SQL Tutorial

PL/SQL Tutorial

In the late 1980’s, Oracle corporation has built the PL/SQL programming language. The PL/SQL is a procedural expansion language for oracle relational database and structure query language. PLSQL Tutorial gives clear description of what is PL/SQL, its features and advantages.

The following are some key facts of the PL/SQL language.

 

What is PL/SQL

Oracle database allows to create tables,objects,and execute all the familiar SQL statements like INSERT,UPDATE and DELETE.In addition,it also offers PL/SQL a very powerful and flexible procedural language,which gives us the ability to tie these SQL statements together.It gives us the ability to write procedural language,to create loops,perform conditional executions and provides a huge built-in setup,which gives fine control on execution of statements.And PL/SQL helps in defining business logic more efficiently and allows the clients to create reusable units of work.

Features of PL/SQL

The following are some key features of PL/SQL which will be learned form PLSQL Tutorial.

  • PL/SQL consists of numerous datatypes.
  • Performs error checking extensively.
  • PL/SQL co-ordinates with the structure query language.
  • Changes made to the server pages and web applications will be upheld by PL/SQL.
  • Object oriented programming language is upheld by PL/SQL.
  • Diverse programming structures will be given by PL/SQL.

Advantages of PL/SQL

The following are a few advantages of PL/SQL.

  • PL/SQL stands for procedural oriented language and is integrated with the structure query language.
  • PL/SQL coordinates with the structure query language.
  • Dynamic and static SQL are supported by PL/SQL.
  • At some point of time, the entire block of statements will be allowed to the database.
  • Provides high productivity to client programmers and can execute update statements inside the database.
  • All the applications run in the PL/SQLare completely portable.
  • Pre-defined sql packages can be accessed through PL/SQL.
  • PL/SQL supports Object oriented programming language
  • Transaction control language and DML operations are supported under static SQL in PL/SQL block.
  • SQL permits embedding DDL statements under dynamic PL/SQL and SQL sections.
  • Changes made to the server pages and web applications will be upheld by PL/SQL.

Summary

  • PLSQL Tutorial – It is a procedural expansion language developed by the oracle corporation.
  • Features of PL/SQL – Performance is the key feature of the PL/SQL database.
  • Advantages of PL/SQL – Advantages includes the flexibility and integrity of the database.