当以下信息不确定时,需用到动态sql语句:
1.sql语句正文
2.主变量的个数
3.主变量的数据类型
4.sql语句中引用的数据库对象(eg.列、索引、基本表、视图等)
例如:先声明变量 lpa_delete VARCHAR2(30000);
.....begin
.......
lpa_delete := 'DELETE FROM T_11_Q' || LPA_TBNAME ||
'A WHERE AAE043 = ' || TO_CHAR(rec_aab301.aae043) ||
' AND AAB301 = ' || TO_CHAR(rec_aab301.aab301);
EXECUTE IMMEDIATE lpa_delete;
......