I am trying to insert a row that numbers each row. I cannot seem to find a function that does this. Does anyone know how to do this? Any help would be appreciated.

Use a sequence. Here's an example.

create sequence s ;

Sequence created.


create table t ( c number );

Table created.


insert into t values ( s.nextval );

1 row created.

insert into t values ( s.nextval );

1 row created.

insert into t values ( s.nextval );

1 row created.

insert into t values ( s.nextval );

1 row created.


select * from t;

C
----------
1
2
3
4

4 rows selected.

--
Joe Fuda
SQL Snippets: Tutorials for Oracle Developers