The Advantage of Oracle Pl/Sql

Posted by kathiravan on March 6th, 2019

Pl/Sql is Oracle’s own language for developing database applications. In additional to supporting all sql operations that oracle SQL Support, Pl/Sql adds programming language extensions such as conditional statement processing loops variables cursor operations, abstract datatypes, modularization, encapsulation, overloading, and more.

Pl/Sql is stored in the Oracle database, dramatically improving performance.

Pl/Sql is especially adept at processing large blocks of data.

Pl/Sql comes with lots of Oracle-supplied code to assist in performing tasks.

Pl/Sql Can be integrated into database tables via triggers.

Pl/Sql supports encapsulation and modularization.

Pl/sql Supports overloading.

Pl/Sql allows programmers to package their oracle code.

Pl/Sql supports named and anonymous programs.