Sorting the Table Records

[MURALI KRISHNA]

i have a table with the following columns

"msisdn sim balance status"
9954656525 154896245126895 120 A
9954656526 154896245121589 160 A

we do some transactions on perticular msisdn then automatically balance ,status would change ..

my requirement is i need to sort the rows based on updations made on the rows

now i dont have creation date,updation date column in my table
if i have those columns then the task is simple

without those columns (creation date,updation date )is there any way to sort the rows in the table

 

[Marco Kalter]

I don't think so. You will need to add a modification_date column and create a little trigger to update this column automatically.