EXPERT RESPONSE
So that database vendors can provide features that differentiate their product from other vendors – to provide sought out flexibility to IT professionals for their particular DBMS.
PL/SQL is the procedural language extension for ORACLE that allows programmers for writing their own procedures and functions as well as using the vast array of built-ins or APIs to process, manipulate, transform and present data retrieved from the ORACLE database that can not be achieved by strict or pure SQL.
You can use PL/SQL for displaying a simple output of "Hello world" to building complex applications.
|