What is PL SQL and why it is used for?
PL/SQL is the language which is used to write the codes in the database.
For Example - PL/SQL is used to write the ORACLE database.PL/SQL is basically to combine the SQL and the procedural feature of the programming language. This language was developed to enhance the characteristics of the SQL language.
Some of the features of the PL/SQL are:-
- PL/SQL functions can be called directly from the SQL.
- PL/SQL can run without the involvement of human.
- Programs can run on the different Operating Systems.
- PL/SQL supports Loops, Conditions, and OOPS concepts.