Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: *****time stamp on same table:pl/sql****
Hi all,
again an issue
this trigger I have to use for some tables in one schema
which is having tables with this userid and updt_time column in them,
Shall I use it seperately for each table in that schema or I can use it in schema level, if so what will be in case of the tables do not have that column (userid and updt_time)
please give some idea
rcy
In article <8bgo8h$mdr$1_at_nnrp1.deja.com>,
dhruba <tapashc_at_my-deja.com> wrote:
> Hi sybrand
>
> Thanks for your reply,
> one more issue
>
> in my table the "usr_id" column is number
>
> little more please
>
> rcy
>
> In article <953931297.22693.3.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > 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.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 27 2000 - 00:00:00 CST