Oracle 视图—参数视图

-----存储过程头---

create or replace package p_view_param_test is
--参数一
function set_baseid(val varchar2) return varchar2;
function get_baseid return varchar2;
--参数二
function set_date(val number) return number;
function get_date return number;

end p_view_param_test;

 

-----存储过程行---

create or replace package body p_view_param_test is
paramValue varchar2(100);
paramValue1 number;

-- baseid
function set_baseid(val varchar2) return varchar2 is
begin
paramValue := val;
return val;
end;

function get_baseid return varchar2 is
begin
return paramValue;
end;
-- basecreatedate

function set_date(val number) return number is
begin
paramValue1 := val;
return val;
end;

function get_date return number is
begin
return paramValue1;
end;
end p_view_param_test;

 

 

 

 ---创建视图

create or replace view view_test as
select * from cux_xx_test where baseid =p_view_param_test.get_baseid() and basecreatedate =p_view_param_test.get_date();

 

--调用案例:
select *
from view_test
where p_view_param_test.set_baseid(124) = 124;

 

posted @ 2024-03-20 09:21  Iven_lin  阅读(301)  评论(0编辑  收藏  举报