EXECUTE IMMEDIATE dynamic sql in procedure
EXECUTE IMMEDIATE dynamic sql to alter session
SQL> DECLARE
2 lv_sql_txt VARCHAR2(200);
3 BEGIN
4 EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE';
5 lv_sql_txt := 'ALTER SESSION SET SORT_AREA_SIZE = 1000000';
6 EXECUTE IMMEDIATE lv_sql_txt;
7 END;
8 /
PL/SQL procedure successfully completed.
SQL> DECLARE
2 lv_sql_txt VARCHAR2(200);
3 BEGIN
4 EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE';
5 lv_sql_txt := 'ALTER SESSION SET SORT_AREA_SIZE = 1000000';
6 EXECUTE IMMEDIATE lv_sql_txt;
7 END;
8 /
PL/SQL procedure successfully completed.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9252210/viewspace-677301/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
