--创建28位自动增长数
create sequence S_S_DEPART
minvalue 1
maxvalue 9999999999999999999999999999
start with 9411391216320139121630000000
increment by 1
nocache;
--创建32为自动增长id,并插入数据库
insert into organization t(t.id,t.organ_name,t.open_flag,t.create_user,t.create_datetime)
values(concat('4028',S_S_Depart.Nextval),'啊啊啊啊啊啊啊啊',1,'张三五',to_date('2012-10-30 05:00:00','YYYY-MM-DD HH:MI:SS'));