O'Reilly logo

Oracle Database 11g PL/SQL Programming by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 11Dynamic SQL

Native Dynamic SQL (NDS) delivered in Oracle 9i, improved in 10g and 11g, provides a replacement for all but one feature of the DBMS_SQL package. NDS is the future and you should consider moving any remaining DBMS_SQL code forward at the earliest opportunity. NDS and the DBMS_SQL package let you create and execute SQL at run time.

This chapter is divided into three principal areas:

Image Dynamic SQL architecture

Image Native Dynamic SQL (NDS)

Dynamic statements

Dynamic statements with inputs

Dynamic statements with inputs and outputs ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required