摘要:
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 阅读全文