Oracle Database 12c PL/SQL Programming

CHAPTER

13

Dynamic SQL

Native Dynamic SQL (NDS), delivered in Oracle 9i Database and improved in Oracle Database 10g, 11g, and 12c, provides a replacement for all but two key features of the dbms_sql package. So, NDS is the future, but dbms_sql isn’t quite the past. While you should consider moving appropriate dbms_sql code forward at the earliest opportunity, some dbms_sql code will remain relevant for awhile. NDS and the dbms_sql package let you create and execute SQL at runtime.

The chapter is divided into three principal areas:

   Dynamic SQL ...