OraFAQ Forum: Forms » Need Time stamp value

Home » Developer & Programmer » Forms » Need Time stamp value (Forms 6i, 6, Xp)

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

Need Time stamp value [message #312191]

Tue, 08 April 2008 02:59

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

Littlefoot
Messages: 21826
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 18 08:58:05 CDT 2026