Oracle PL/SQL Block Structure

PL/SQL was developed by modeling the concepts of structured programming, static data typing, modularity, exception management, and parallel processing found in the Ada programming language. The Ada programming language, developed for the United States Department of Defense, was designed to support military real-time and safety-critical embedded systems, such as those in airplanes and missiles. The Ada programming language borrowed significant syntax from the Pascal programming language, including the assignment and comparison operators and the single-quote string delimiters.

Choosing the Ada programming language made sense for a number of reasons. Three reasons were that SQL adopted the Pascal operators, string ...

Get Oracle Database 10g Express Edition PHP Web Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.