SQL> create table userinfo(
2 id int default usidsqn.nextval);
id int default usidsqn.nextval)
*
ERROR at line 2:
ORA-00984: column not allowed here
2 id int default usidsqn.nextval);
id int default usidsqn.nextval)
*
ERROR at line 2:
ORA-00984: column not allowed here
再建一个trigger:
CREATE or replace trigger Trig_for_insert
before insert on userinfo
for each row
BEGIN
select USIDSQN.nextval into :new.ID from dual;
END;
/