image

image

racle introduced the PL/SQL programming language more than 20 years ago in the Oracle 6 database. PL/SQL provides a procedural extension to SQL and lets you call SQL from a PL/SQL program, or vice versa. This chapter introduces you to the basics of writing stored programs in Oracle 11g and provides a summary overview of PL/SQL. You can find more complete treatment in Oracle Database 11g PL/SQL Programming.

Chapter 4 showed you the concept of transactional units built with combinations of INSERT, UPDATE, and DELETE statements. It also introduced ...

Get Oracle Database 11g & MySQL 5.6 Developer Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.