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