Re: help me pls

Hi,
Are you saying you want to insert the date/time when you insert a new row? If so, you can do
that by creating a column in your table called "DateCreated", "DateInserted", something like that. You can make sysdate the default for that column. When you insert your other values the time will be recorded that way.
I hope this helps,
S

C.K. wrote:

> i really need some help on this,
>
> i'm trying to fire a trigger after/before(this doesn't matter) i insert a
> record into the database.
> The problem is that, during the time of running the trigger, i have to add
> some data to the inserting record; like.. the time of insert, something like
> that.
> i know that using a temp table, and run the trigger thru the insert of temp
> table will be easier, however, due to some restriction, i can't do that, can
> anybody tell me a better way so that i can edit the data while i'm inserting
> it to the table?
> pls help me out!
>
>
>
Received on Wed Mar 07 2001 - 11:36:24 CST