declare
str varchar2(500);
c_1 varchar2(100);
r_1 varchar2(100);
begin
c_1:='测试人员';
str:='select :c from dual';
execute immediate str into r_1 using c_1;
DBMS_OUTPUT.PUT_LINE(c_1||'==='||r_1);
str:='select 123 from dual';
execute immediate str into r_1 ;
DBMS_OUTPUT.PUT_LINE(c_1||'==='||r_1);
end ;
ORACLE动态语句
最新推荐文章于 2022-11-16 15:00:26 发布