PL/SQL also has an exception handling block that handles the exceptions in PL/SQL.Įxtensive error checking is also possible using PL/SQL We can also reuse PL/SQL units such as functions, triggers, procedures, etc that are stored in the database after the creation. Using a single command, PL/SQL can execute a number of queries. PL/SQL provides the functionality of a procedural language such as decision making, iteration, etc. Oracle created PL/SQL that extends some limitations of SQL to provide a more comprehensive solution for building mission-critical applications running on the oracle database. It stands for procedural language extension to the structured query language. The following topics are covered in this article. In this PL/SQL tutorial, we will go through the basic concepts of PL/SQL in detail. It is an extension of SQL and we can even use SQL queries without any hassle in any PL/SQL application or program. PL/SQL is a procedural language that overcomes the shortcomings faced by Structured Query Language.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |