Capture rows for a column in file from delete sql -Oracle

view story

http://www.unix.com – Hi, This may not be the right forum but i am hoping someone knows an answer to this. I have to capture rows for a column that was deleted. How can i do that without having to write a select query? delete from myschema.mytable where currentdatetimestamp > columnDate this should delete 5 rows for example I want to capture rows of columnID (not all the columns of the table) in a text file that was affected by the above file should have 1234 1235 1236 1237 1238 Thanks - jak (HowTos)