Introduction to the concept of PL/SQL and its uses
What is the purpose of the language PL/SQL? What are its advantages over SQL Query Language? Where is it used?
What is the purpose of the language PL/SQL? What are its advantages over SQL Query Language? Where is it used?
Hi
PL/SQL is an improvement over the SQL Language developed by Oracle to enhance the features of SQL. It has the same syntax as SQL. PL/SQL is an acronym for Procedural Language/ Structured Query Language. This Language brings about optimal efficiency. The PL/SQL Language inherits security, portability, and robustness of the Oracle Database. The applications of PL/SQL are found in web applications development. The advantages of PL/SQL are-
A. Procedural Language Support
B. Error Handling
C. Portable Application
D. Declare Variable