Alter RowID Sequence

I have an application that will process rows within a table based on the increasing RowID Value. What I am aiming to do is to massage the data to allow for changing the sequence in which items are processed while still using the RowID as the sequence number.

e.g. Table1
RowID Value

1      4
2      3
3      5
4      6

I have an identical table called Table2

I tried:
Insert into Table2 Select * from Table1 Order by Value;

Based on the assumption that this would create the following in Table2: RowID Value

1      3
2      4
3      5
4      6

However, I get the following error.
ORA-00933: SQL command not properly ended

Then I planned on using
Delete from Table1;
Insert into Table1 Select * from Table2; Delete from Table2;

Any suggestions welcomed.

Regards,
TABates

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 09 1999 - 16:48:26 CDT