OraFAQ Forum: SQL & PL/SQL » Modified Date and Time of a Row

Home » SQL & PL/SQL » SQL & PL/SQL » Modified Date and Time of a Row

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Modified Date and Time of a Row [message #36949]

Mon, 07 January 2002 05:29

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

Report message to a moderator

Re: Modified Date and Time of a Row [message #36953 is a reply to message #36949]

Mon, 07 January 2002 06:27

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.

Report message to a moderator

Re: Modified Date and Time of a Row [message #36957 is a reply to message #36949]

Mon, 07 January 2002 10:28

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,

Report message to a moderator

Previous Topic:	Executing PL/SQL from a file
Next Topic:	How to I execute a function inside a package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 21 00:57:14 CDT 2025