DB研討會 : [轉貼]Oracle 欄位自動流水號真是不人性化

SELECT OXQ_TABLE_S.nextval, T.*
FROM OXQ_TABLE T

-- Create sequence
create sequence OXQ_TABLE_S
minvalue 1
maxvalue 2147483647
start with 1
increment by 1
cache 1000
;

CREATE TABLE OXQ_TABLE (
  id          NUMBER DEFAULT OXQ_TABLE_S.NEXTVAL,
  description VARCHAR2(30)
);