创建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()