|
Unfortunately, Oracle does not support auto increment fields
like SQLServer, MySQL.
If you need key field which should has a unique value, you
should use more comlex way.
In Oracle, we use SEQUENCEs to create auto increment fields. Create a sequence and
an insert trigger.
BEGIN
select
"MYSCHEMA"."MYSEQ".nextval
into
:new.ID
from
dual
;
END;
As an alternative, you can use sequence name directly in your SQL statement.
insert into MyTable(Id,FirstName,LastName) values (MySeq.nextval,'Celine','Dion')
|