创建Oracle视，动态关联表

create or replace procedure p_countyarea_param as
paramValue varchar2(10);
v_sql varchar2(5000);
begin
select to_char(sysdate,'yyyymm') into paramValue from dual;
v_sql:=' create or replace view p_view_user as
select *
from tbl_'||paramValue||' ';
EXECUTE IMMEDIATE v_sql;
commit;
end;

 

 

//百度 出来的例子

Package：
create or replace package p_countyarea_param is
--为视图创建变量
function set_param(datetime varchar2) return varchar2;
function get_param return varchar2;
end p_countyarea_param;

Package Body：
create or replace package body p_countyarea_param is
--记住日期时间的
paramValue varchar2(10);
function set_param(datetime varchar2) return varchar2 is
begin
paramValue := datetime;
return datetime;
end;

function get_param return varchar2 is
begin
return paramValue;
end;
end p_countyarea_param;

create or replace view p_view_user as
select *
from p_countyarea_param.get_param()

转载于:https://www.cnblogs.com/irisjyf/p/7510574.html