那位大侠知道在oracle存储过程中如何创建表,并且表名根据日期变化,如:
select to_char(sysdate-1,'yyyymmdd') into v_temp_time from dual;表名: lmf_acct_item_'||v_temp_time||'
属性: SERV_ID NUMBER(12) not null,
ACCT_ID NUMBER(12) not null,
ACCT_ITEM_ID NUMBER(12) not null,
ACCT_ITEM_TYPE_ID NUMBER(9) not null,
CREATED_DATE DATE not null,
STATE_DATE DATE not null,
ACCT_CHARGE NUMBER,
ACCT_MONTH CHAR(6) not null,
CHARGE NUMBER(10) not null,
CHARGE_GET NUMBER(10) not null,
REGION_ID NUMBER(15),
PRODUCT_OFFER_ID NUMBER(15),
PRODUCT_ID NUMBER(15),
ACC_NBR NUMBER(16),
CUST_ID NUMBER(16)
小弟求各位大侠帮忙
select to_char(sysdate-1,'yyyymmdd') into v_temp_time from dual;表名: lmf_acct_item_'||v_temp_time||'
属性: SERV_ID NUMBER(12) not null,
ACCT_ID NUMBER(12) not null,
ACCT_ITEM_ID NUMBER(12) not null,
ACCT_ITEM_TYPE_ID NUMBER(9) not null,
CREATED_DATE DATE not null,
STATE_DATE DATE not null,
ACCT_CHARGE NUMBER,
ACCT_MONTH CHAR(6) not null,
CHARGE NUMBER(10) not null,
CHARGE_GET NUMBER(10) not null,
REGION_ID NUMBER(15),
PRODUCT_OFFER_ID NUMBER(15),
PRODUCT_ID NUMBER(15),
ACC_NBR NUMBER(16),
CUST_ID NUMBER(16)
小弟求各位大侠帮忙
tempsql varchar2(2000);tempsql:='create or replact table lmf_acct_item_'||v_temp_time ¦ ¦' (
SERV_ID NUMBER(12) not null,
ACCT_ID NUMBER(12) not null,
ACCT_ITEM_ID NUMBER(12) not null,
ACCT_ITEM_TYPE_ID NUMBER(9) not null,
CREATED_DATE DATE not null,
STATE_DATE DATE not null,
ACCT_CHARGE NUMBER,
ACCT_MONTH CHAR(6) not null,
CHARGE NUMBER(10) not null,
CHARGE_GET NUMBER(10) not null,
REGION_ID NUMBER(15),
PRODUCT_OFFER_ID NUMBER(15),
PRODUCT_ID NUMBER(15),
ACC_NBR NUMBER(16),
CUST_ID NUMBER(16) )';execute immediate tempsql;