摘要: 1.创建用户数据表CREATE TABLE USERTEST(id number not null,uname varchar2(20) not null,upass varchar2(20) not null);2.创建自动增长的序列create sequence ID_SEQminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1cache 20order;3.创建触发器,在执行插入操作的时候触发create or replace trigger uid_triggerbefore insert onU 阅读全文
posted @ 2012-07-18 11:47 shenrq163 阅读(154) 评论(0) 推荐(0) 编辑