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;
本文来自博客园,作者:Iven_lin,转载请注明原文链接:https://www.cnblogs.com/ivenlin/p/18084447