last modifications in column in table oracle 10g

[smsintel]

hi
plzz tell me query
last modifications in column in table oracle 10g

[rski]

There is no such column for DMLs, for DDL you have last_ddl_time.

To have last time for DML you will need to create a column which will be updated/inserted when proper SQL query is executed, but you have to do populate that column by yourself.

[gaurishere]

Dear user

desc dba_tab_modifications

from here you can find when the last insert,update,d elete was happened on the table