oracle table data query
Posted on 2007-11-27
Hi...i'm a little lost how to fix this....i have a table created by a inexperienced programmer....the table has been created without a sequence no or primary key..it has a entry date column but a lot of the data in it is date truncated....
I want to fix the table by adding a sequence no...how do i know the order of data in the table.....if i order it by rownum or rowid, it returns the data inconsistently....data with earlier entry dates appear later than data with later entry dates...is there any wany to retrive the data in the way order it entered the table?
i would'nt mond even moving all the data into another table with a primary key, but i want to keep the order of the table intact..