oracle执行动态SQL语句

declare
  empRec emp%rowtype;
  sqlStr varchar2(200);
begin
  --DDL动态SQL语句--
  execute immediate 'create table test(id number(4))';
 
  --带绑定变量的动态SQL语句--
  sqlStr:='select * from emp where empno=:id';
  execute immediate sqlStr into empRec using 7934;
  dbms_output.put_line(empRec.ename);

  --字符串联接生成的动态SQL语句--
  sqlStr:='select * from emp'||' '||'where empno=7788';
  execute immediate sqlStr into empRec;
  dbms_output.put_line(empRec.ename);
end;