Hi Everyone,
Please help me on this. Thanks.
Please help me on this. Thanks.
Code:
CREATE TABLE PREMIA_BONUS_REF
(
PC_CODE VARCHAR2(50) ,
POL_PROD_CODE VARCHAR2(50) ,
POBH_MKT_CODE VARCHAR2(50) ,
AGENT_RANK_DESC VARCHAR2(50) ,
BONUS_RATE NUMBER(14,3)
START_DATE DATE,
END_DATE DATE,
CREATED_ON DATE default sysdate,
CREATED_BY VARCHAR2(30) default user,
MODIFIED_ON DATE default sysdate,
MODIFIED_BY VARCHAR2(30) default user,
)
TABLESPACE FFCCPOL
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 20K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL