17,382
社区成员




create table Dict_System"
(
ID NUMBER(4),
PID NUMBER(4),
NodeName VARCHAR(20),
PathName VARCHAR(200),
OrderIndex NUMBER(2),
IsEnable NUMBER(1)
)
create sequence SEQ_DICT
minvalue 1
maxvalue 9999
start with 1
increment by 1
cache 20
order;
create or replace trigger Trig_Dict
before insert on dict_system
for each row
begin
select seq_dict.nextval into: new.id from dual;
end Trig_Dict;
insert into dict_system (pid,nodename,pathname,orderindex,isenable) values ('0','系统设置','system','1','1');