oracle数据库中的表如何设置自增字段

1. 创建序列

create sequence myuserseq start with 1 

2.向表中插入元组

用 myuserseq.nextval 值替换要插入自增字段的值

INSERT INTO userinfo VALUES(myuserseq.nextval,'cuihua','123',0)

3.查看插入的序列值

select * from userinfo

 4.查看当前序列

select myuserseq.currval from dual