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 ;
09-24
09-24