个人笔记

select t.*, t.rowid from SYS_RESTCACHE t

drop table SYS_RESTCACHE

drop table SYS_RESTCACHE cascade constraints;

/*==============================================================*/
/* Table: SYS_RESTCACHE                                         */
/*==============================================================*/
create table SYS_RESTCACHE  (
   ID                   varchar(20),                         
   REQUEST_PARAMS       VARCHAR(1024),
   REQUEST_FIRSTTIME    DATE,
   RESPONSE_COLB        clob,
   ACTIONANE           varchar(50),
   RESPONSE_JSON       long,
   constraint PK_SYS_RESTCACHE primary key (ID)
);

--create sequence 序列号名

--minvalue 最小值
--maxvalue 最大值

--start with 目前值
--increment by 步长

--nocache;
--列子
create  sequence cache_sequence
minvalue 1
maxvalue 999999999999999999999999999
start with 15
increment by 1
nocache;
drop trigger trig_score;--删除触发器

create or replace trigger RESTCACHE_TRIGGER       
before insert on SYS_RESTCACHE       
for each row       
begin       
select cache_sequence.nextval into :new.ID from dual;      
end ;  

insert into SYS_RESTCACHE(SYS_RESTCACHE.REQUEST_PARAMS,RESPONSE_COLB) values('12312432',empty_clob())

TRUNCATE TABLE SYS_RESTCACHE