CS Study

What is PL/SQL ? PL SQL is a procedural language which has interactive SQL, as well as procedural programming language constructs like conditional branching and iteration.

1. Compare SQL & PL/SQL Criteria SQL PL/SQL What it is Single query or command execution Full programming language What it comprises Data source for reports, web pages Application language to build, format and display report, web pages Characteristic Declarative in nature Procedural in nature Used for Manipulating data Creating applications