分类: Oracle
2010-01-20 14:51:41
chinaunix网友2010-01-28 14:54:18
oracle中execute immediate的使用(select/insert/update/delete) 转的网上的,execute immediate http://hi.baidu.com/llscompazz/blog/item/29dccd58851fced99c8204d4.html execute immediate的语法如下: execute immediate 'sql'; execute immediate 'sql_select' into var_1, var_2; execute immediate 'sql' using [in|out|in out] bind_var_1, [in|out|in out] bind_var_2; execute immediate 'sql_select' into var_1, var_2 using [in|out|in out] bind_var_1, [in|out|in out] bind_var_2; execute immediate 'sql' returning into