Chapter 13Dynamic SQL

Dynamic SQL delivered in Oracle 9i provides a replacement for most of the functionality delivered in the Oracle DBMS_SQL built in. It is a powerful technology that lets you do many things that were more difficult when using DBMS_SQL. This chapter will cover both utilities and provide you with comparative examples.

You will cover topics as follows. The chapter assumes you read it sequentially. It also assumes you have read the preceding twelve chapters. If you feel comfortable with an area, please feel free to move to the section of interest. However, the chapter assumes you have mastery of earlier sections.

Image Introducing dynamic ...

Get Oracle Database 10g PL/SQL 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.