The Use of the DBMS_SQL System Package of Oracle Dynamic SQL
Shi Xiao-ling · Journal of Hunan Industry Polytechnic · 2010
Oracle Dynamic SQL is a a high-level content of PL / SQL procedures development,Using dynamic SQL will be more flexible and powerful in the PL / SQL program development,Therefore,to master the use of dynamic SQL is an important condition to improve the PL / SQL development capability.This paper describes DBMS_SQL system package structure,as well as the basic usage and some techniques of realizing dynamic SQL through DBMS_SQL package by some examples.