How do i define autoincrement column in oracle

[2314]

How do i define autoincrement column in oracle as i do in sql server with identity column.

 

[sem]

Read about SEQUENCEs.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

2314,

Here are some sample structures and invocation that should enhance and illustrate whatever reading you do on the topic of sequences:

Section 1 -- Creating a sequence:

create sequence seq_2314;

Sequence created.

Section 2 -- Using the sequence (in the table I built for your question regarding "DEFAULT" last night):

SQL> insert into tab2314 (ID) values (seq_2314.nextval);

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> select * from tab2314;

        ID CREATE_DA
---------- ---------
         1 16-NOV-04
         2 16-NOV-04
         3 16-NOV-04
         4 16-NOV-04

5 rows selected.

Does this answer your questions regarding Oracle's counterpart for SQL Server's AUTOINCREMENT column?

Mufasa
(aka Dave of Sandy, Utah, USA)
e-mail: dave@dasages.com
@ 16:14 (16Nov04) UTC (aka "GMT" and "Zulu"),
@ 09:14 (16Nov04) Mountain Time

 

[DBAwhosaysNIE]

you probably want to create a before insert trigger to force use of the sequence value. I wouldn't trust the app code/developer but that's just me...