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:
Dynamic SQL architecture
Native Dynamic SQL (NDS)
Dynamic statements with inputs
Dynamic statements with inputs and outputs ...