oracle資料庫的建立自增id

create table CONFIG_PRESCRIPTION_GGG(
  id  VARCHAR2(20) not null primary key,
  name VARCHAR2(255) not null,
  name_url VARCHAR2(255)
);

-- 建立序列 --
create sequence ID_SEQ_EVAGGG
 increment by 1
 start with 1
 minvalue 1
 maxvalue 999999999;

--擷取序列自增ID --
select ID_SEQ_EVAGGG.Nextval ID from dual;