declare
s_sql varchar(1000):='update jobs set job_title='President' where job_id='AD_PRES'';
retCnt number;
job_id varchar2(100);
job_title varchar2(300);
begin
dbms_output.put_line('----------------记录更新数值-------------------');
dbms_output.put_line('测试SQL:'||s_sql);
execute immediate s_sql;
retCnt:=sql%rowcount;
dbms_output.put_line(retCnt);
dbms_output.put_line('----------------记录数-------------------');
s_sql:='select count(*) from jobs ';
execute immediate s_sql into retCnt;
dbms_output.put_line(retCnt);
dbms_output.put_line('--------------赋值--------------------');
s_sql:='select job_id,job_title from jobs where job_id='AD_PRES' ';
execute immediate s_sql into job_id,job_title;
dbms_output.put_line(job_id||'====>>>'||job_title);
rollback;
end;