Use PL/SQL for data manipulation and processing. PL/SQL:
-
Oracle's procedural SQL application development language
-
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 programming language between C and SQL: loops, decisions, modules and function calls, subroutines, etc.
-
database server is both a SQL engine and a computing engine
-
programmable HTML pages - program dynamic html pages on the fly
|
