Home » Developer & Programmer » Forms » Need Time stamp value (Forms 6i, 6, Xp)
Need Time stamp value [message #312191] Tue, 08 April 2008 02:59 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Friends,

I wanted to know when we insert a record does oracle store its time stamp like the rowid of each row.

And if it does then how can we get a record's time stamp through SELECT statement or through FORMS?

Regards,
Azam Khan
Re: Need Time stamp value [message #312203 is a reply to message #312191] Tue, 08 April 2008 03:39 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, timestamp doesn't exist by default. If you need to use it, use ALTER TABLE statement and add such a column; make sure to fill its value during every insert operation (perhaps even on updates?). Afterwards, simply select it as any other column.
Re: Need Time stamp value [message #312207 is a reply to message #312203] Tue, 08 April 2008 03:42 Go to previous message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Yes that I was thinking to do. But if like ROWID this column also exist then how wounderful it would be Cool

Any ways thanks...

Regards,
Azam Khan
Previous Topic: About SQL Loader in Form
Next Topic: Forms locking
Goto Forum:
  


Current Time: Sat Dec 03 01:27:07 CST 2016

Total time taken to generate the page: 0.10757 seconds