Oracle 带参视图
创建包:create or replace package p_view_paramis
function set_param(num number) return number;
function get_paramreturn number;
end p_view_param;
create or replace package body p_view_param is
paramValue number;
function set_param(num number) return number is
begin
paramValue:=num;
return num;
end;
function get_param return number is
begin
return paramValue;
end;
end p_view_param;
视图的建立:
create or replace view p_view_user as
select> PL/SQL调用:
select * from p_view_user where p_view_param.set_param(2781)=2781
页:
[1]