Home » Developer & Programmer » Forms » Insert the date and time automatically in table (10g form builder,11gdb)
Insert the date and time automatically in table [message #583275] Mon, 29 April 2013 01:45 Go to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
hi....

i have emp table of 5 columns empno,ename,dept,sal,edit_timing(edit timing datatype is timestamp).


and my form contains empno,ename,dept,sal.

and my question is if i insert a record into forms it automatically insert the date and timing into edit_timing columns.
Re: Insert the date and time automatically in table [message #583276 is a reply to message #583275] Mon, 29 April 2013 01:47 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option is to create a database trigger which will do that job.
Re: Insert the date and time automatically in table [message #583277 is a reply to message #583276] Mon, 29 April 2013 01:49 Go to previous message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
yes....thank you..
Previous Topic: date format DD / MM / YYYY
Next Topic: How to print & in Title
Goto Forum:
  


Current Time: Tue Apr 16 12:38:10 CDT 2024