HELP! * GREY=local LOCAL HTML version of Foils prepared Jan 8, 1996

Foil 17 Procedural and Programmable mechanisms

From Integration of Web and Relational Databases CPS600 Spring Semester -- April 1995. by Gang Cheng (Geoffrey Fox) * See also color IMAGE

use PL/SQL for data manipulation and processing.
PL/SQL is
  • Oracle's procedural language for SQL application development
  • support stored procedures, database triggers, optimized concurrent data access, and executable programs as meta-data (i.e., programs are stored together with and attached to the data objects to be manipulated on)
  • a database programming language with expressive capability between C and SQL: loops, decisions, modules and function calls, subroutines, etc.
  • database server is both a SQL engine and a compute engine
  • programmable HTML pages



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 Tue Feb 18 1997