Oracle通用日志表设计。
– Create sequence
create sequence SEQ_COMMON_LOG
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
– Create table
create table TU_COMMON_LOG
(
COL_SEQUENCE NUMBER(20) not null,
COL_DATE DATE default sysdate not null,
COL[......]