Scribd
Upload
5 views4 pages

Understanding PL/SQL: Features & Benefits

PL/SQL is Oracle Corporation's standard language that provides a programming extension to standard SQL, allowing developers to write portable, high-performance transaction-processing applications. It tightly integrates with SQL, offers high productivity, and supports object-oriented programming, web applications, server pages, and features like error handling, blocks, variables, subprograms, packages, triggers, input/output, and processing query result sets row by row.

Uploaded by

Anonymous zOLgWrG
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
5 views4 pages

Understanding PL/SQL: Features & Benefits

PL/SQL is Oracle Corporation's standard language that provides a programming extension to standard SQL, allowing developers to write portable, high-performance transaction-processing applications. It tightly integrates with SQL, offers high productivity, and supports object-oriented programming, web applications, server pages, and features like error handling, blocks, variables, subprograms, packages, triggers, input/output, and processing query result sets row by row.

Uploaded by

Anonymous zOLgWrG
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

By Roopali Patil

EXPERTISERS TRAINING INSTITUTE

What is PL/SQL?
PL/SQL stands for Procedural Language extension to SQL
Oracle Corporations standard relational database data

access language.
SQL is simple and un-conditional.
PL\SQL provides a programming extension to standard
SQL.
Portable, high-performance transaction-processing
language.

Advantages of PL\SQL
Tight Integration with SQL
High Performance
High Productivity

Portability
Scalability
Manageability
Support for OOP
Support for Developing Web Applications
Support for Developing Server Pages

Features of PL/SQL

Error Handling
Blocks
Variables and Constants
Subprograms
Packages
Triggers
Input and Output
Data Abstraction
Control Statements
Conditional Compilation
Processing a Query Result Set One Row at a Time

You might also like