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