Re: how to set the column be auto increment no.??

> I want to create a table with a field called "seqno" that is a auto
> increment number. What is the stynax of setting auto increment??
>
> Now, I create my table temporily by this statement:
> create table AAA (seqno number(10) not null)
>
> thx

SQL> create sequence myseq;

Sequence created.

SQL> create table AAA (seqno number(10) not null);

Table created.

Elapsed: 00:00:00.06
SQL> insert into AAA values (myseq.nextval);

1 row created.

Elapsed: 00:00:00.02
SQL> commit;

Commit complete.

HTH Daniel Received on Fri Jul 04 2003 - 10:52:25 CDT