Other features of PL/SQL can be summarized below and refer this for detailed explanation. PL/SQL relies on SQL(standard relational database declarative language) for data retrieval and uses its own constructs for data processing.In other words, PL/SQL integrates data-manipulating power of SQL with the processing power of procedural languages and makes PL/SQL highly flexible, efficient. Why do we need PL/SQL : - "To add/shift business logic at the database level." etc) to standard relational database language(SQL).PL/SQL is used in Oracle relational database, in the Oracle Server, and in Oracle Forms,Oracle reports(client-side application development tools). It adds procedural programming constructs(IF, ELSE, ERROR, EXCEPTION. PL/SQL stands for "Procedural Language extensions to SQL." It is tightly integrated with SQL and fully supports SQL data types.
0 kommentar(er)
