加个序列就ok了csdn的老贴很多,搜一下:http://community.csdn.net/Expert/ForumList_Search.asp?searchtype=2&bigclassid=61&smallclassid=6101&searchKeys=%D0%F2%C1%D0&author=&tabletype=now&Submit2=%B6%D4%D1%A1%D4%F1%B5%C4%D0%A1%C0%E0%BD%F8%D0%D0%CB%D1%CB%F7
调试欢乐多
increment by 1
start with 1
maxvalue 100
minvalue 1
nocycle
nocache;
首先创建create or replace sequence seq
increment by 1
start with 1
maxvalue 999999999999999999 minvalue 1 nocycle; 够不?^_^
使用的时候,在插入数据的时候 insert into webtime values (seq.nextval,**,**);即可完成自动加一的功能