yah,

fine, but suppose i hv updated a column(col1) in a table(tab1)

and there is a trigger which fires after updation so plz tell me how can i get the older col1 value...

thanks Frank,

but i hv heared that it is possible to remove duplicate rows in oracle as oracle keeps the track of each row and generate an unique rowid, and with...

i hv search this problem in sql help but could not find any result