create or replace procedure xp_get (num out int,yourwhere varchar2)
as
begin
execute immediate ' select count(*) from a where xx = ''b'' ' ||yourwhere into num;
end;/declare num int;
begin
xp_get(num,' and deptno=34');
dbms_output.put_line(num);
end;
/
as
begin
execute immediate ' select count(*) from a where xx = ''b'' ' ||yourwhere into num;
end;/declare num int;
begin
xp_get(num,' and deptno=34');
dbms_output.put_line(num);
end;
/
另外在两个“/”之间的那段代码又有什么作用呢?