Description
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.
- PL/SQL contains a working framework independent of programming environment and build_in translated.
- It is a high performance transaction processing and versatile language.
- From SQL*plus command line interface, PL/SQL can be called directly.
- From outer programming language, it can be directly called to the database.
- The syntax structure of PL/SQL is similar to that of pascal programming dialect and ADA.
- PL/SQL is accessible in IBM DB2 and Times Ten in_memory database.
Description
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.
Conceptual
figure
Description
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.
Description
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.
Key Points
- 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.