Home » SQL & PL/SQL » SQL & PL/SQL » Modified Date and Time of a Row
Modified Date and Time of a Row [message #36949] Mon, 07 January 2002 05:29 Go to next message
Rajesh Naik
Messages: 6
Registered: January 2002
Junior Member
How can i get the Time and Date Modified of any row oa any Table in Oracle ?
It is very necessary for me!

Thanks and Regards

Rajesh Naik
Re: Modified Date and Time of a Row [message #36953 is a reply to message #36949] Mon, 07 January 2002 06:27 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
there is no automatic mechanism to record data changes. you have to design tables with 2 columns like creation date, modified date.
Re: Modified Date and Time of a Row [message #36957 is a reply to message #36949] Mon, 07 January 2002 10:28 Go to previous message
raghav banuru
Messages: 6
Registered: January 2002
Junior Member
add a column update_date and pass the sysdate when you update the record in the plsql procedure
this will slove your porb

if you have any Questions let me know.
thanks,
Previous Topic: Executing PL/SQL from a file
Next Topic: How to I execute a function inside a package
Goto Forum:
  


Current Time: Thu Mar 28 20:23:09 CDT 2024