OraFAQ Forum: Weblogic & Application Server » Oracle trigger: auto-insert system date in column after insert

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Oracle trigger: auto-insert system date in column after insert

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

Oracle trigger: auto-insert system date in column after insert [message #76195]

Tue, 02 October 2001 11:38

Kathy
Messages: 10
Registered: October 2000

Junior Member

hi,

i am trying to create a trigger and need help.
i have a table called MyTable with a column called InsertDate. Each time a row is inserted into MyTable table, i want the system date to be populated into InsertDate field. This way i dont have to insert the system date at the application level. The trigger will automatically insert the InsertDate.

I am very new to oracle. Thank you for your help.

----------------------------------------------------------------------

Report message to a moderator

Re: Oracle trigger: auto-insert system date in column after insert [message #76201 is a reply to message #76195]

Tue, 09 October 2001 22:16

timo talja
Messages: 5
Registered: August 2000

Junior Member

Hi Kathy,
please just renu with sqlplus following script:
CREATE TRIGGER TRIG_mytable_INS BEFORE INSERT ON mytable
FOR EACH ROW
BEGIN
:new.insertdate:= sysdate;
END;
/

Cheers,
timo

----------------------------------------------------------------------

Report message to a moderator

Re: Oracle trigger: auto-insert system date in column after insert [message #76220 is a reply to message #76195]

Tue, 30 October 2001 02:04

Frederick Nara
Messages: 1
Registered: October 2001

Junior Member

Try to use default SYSDATE :

create table foo
(mydate date default SYSDATE,
id number);

insert into foo (id) values (1);

select * from foo;

if your table is already created :

alter table foo modify mydate date default SYSDATE;

----------------------------------------------------------------------

Report message to a moderator

Re: Oracle trigger: auto-insert system date in column after insert [message #76276 is a reply to message #76195]

Thu, 10 January 2002 05:26

Dheeraj Mudgil
Messages: 1
Registered: January 2002

Junior Member

Hi if you use the following statement you can achieve what you are tryying to do.

create or replace triggeR mytrig
before insert on emp for each row

:new.InsertDate = sysdate;

end;

Report message to a moderator

Re: Oracle trigger: auto-insert system date in column after insert [message #76441 is a reply to message #76195]

Mon, 01 July 2002 22:50

George
Messages: 68
Registered: April 2001

Member

I think you can use this:
insert into table(insertdatefield) values (sysdate);
or:
insert into table(insertdatefield) values (to_char(sysdate,'yyyy-mm-dd'))

Report message to a moderator

Previous Topic:	Re: trigger from oracle should refresh applet
Next Topic:	unable to install 9iAS under 9i DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:02:49 CDT 2024