oracle创建自增字段

create sequence Seq_NameA
minvalue 1 maxvalue 9999999999999999999999999999 
start with 1 increment by 1 
nocache; 

create or replace trigger Trg_NameA 
before insert on TableA 
for each row 
begin 
select SEQ_pgradge .nextval into :new.id from dual; 
end;