Oracle的存储过程过于麻烦,这里给大家计述一个用视图传递参数的方法。
declare
sqlstr varchar2(8000) :='';
begin
select code into sqlstr from select * from 表1;
sqlstr :=' where 2>1 and 条件..... ';
execute immediate sqlstr;
sqlstr:='create or replace view 视图 as '|| sqlstr;
execute immediate sqlstr;
end;
最后使用普通的视图查询
select * from 视图