Basic HTML version of Foils prepared 7 October 97

Foil 22 PL/SQL - Oracle's Procedural Language to SQL

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
1 Relationship between SQL and PL/SQL
  • PL/SQL is an application development language.
  • while SQL is the basic data access language in Oracle that all other Oracle products and tools use, including PL/SQL engine
  • PL/SQL is a superset of SQL, allowing all the DML statements, cursor operations and the transaction processing statements in SQL
  • SQL is a non-procedural language, only allowing to specify what to do, not how to do.
  • while PL/SQL is the procedual extension of SQL, allowing one to specify both
in Table To:

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998