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 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.