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: 557
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

Report message to a moderator

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: 21818
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.

Report message to a moderator

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: 557
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

Report message to a moderator

Previous Topic: About SQL Loader in Form
Next Topic: Forms locking
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 10:33:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.