Re: Table Design!

SQL> create table tablea (

	colid number,
	col_text varchar2(50));

Table created.

SQL> create sequence tablea_seq

	start with 1
	increment by 1;

Sequence created.

SQL> insert into tablea values (tablea_seq.nextval, 'Row 1');

1 row created.

SQL> insert into tablea values (tablea_seq.nextval, 'Row 2');

1 row created.

SQL> insert into tablea values (tablea_seq.nextval, 'Row 3');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from tablea;

     COLID COL_TEXT

---------- --------------------------------------------------
         1 Row 1
         2 Row 2
         3 Row 3

SQL> Received on Mon Nov 14 2005 - 05:17:18 CST