Re: *****time stamp on same table:pl/sql****

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/24
Message-ID: <953931297.22693.3.pluto.d4ee154e@news.demon.nl>#1/1

correct code

 create or replace trigger ins_tm_uid

        BEFORE INSERT OR UPDATE  ON testtable
        FOR EACH ROW
 ----
        declare


> ----

        begin
        :new.u_tm := SYSDATE;
        :new.usr_id := user;
 ----
       end;

  /
And that is ALL

Hth,

Sybrand Bakker, Oracle DBA

dhruba <tapashc_at_my-deja.com> wrote in message news:8bgh4h$e6m$1_at_nnrp1.deja.com...
> Hi
>
> I have a table testtable
>
> name vc2(10)
> age number
> usr_id number
> u_tm date
>
> i want a trigger so that for any insert or update
>
> usr_id will get userid from user_users
> and u_tm will get current timestamp;
>
> the trigger is giving an error.
>
>
> create or replace trigger ins_tm_uid
> AFTER INSERT OR UPDATE ON testtable
> FOR EACH ROW
> ----
> declare
> time_now date;
> curr_uid user_users.user_id%type;
> ----
> begin
> time_now := SYSDATE;
> ----
> select username into curr_uid from user_users;
> if inserting then
> insert into testtable (usr_id,u_tm) values
> (curr_uid,time_now)
> where name=:new.name;
> end if;
> ----
> end;
>
> /
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 24 2000 - 00:00:00 CST