Re: Trigger Code

From: Tiago Rocha <please.see.link.at.signature.for.email.address_at_zaz.com.br>
Date: Tue, 23 Mar 2004 16:59:09 -0300
Message-ID: <1d516055fiu80s6i97kps1rec7j46e2p04@4ax.com>

On Tue, 23 Mar 2004 11:55:41 -0600, "Redd" <javatek?@usa.com> wrote:

>Feel free to test it yourself.

SQL> create table test (quantity number(10),

  2                     oldquantity number(10),
  3                     onorder varchar2(1) );

Table created.

SQL> create or replace trigger sample_trigger   2 before insert or update on test
  3 for each row when (new.quantity > old.quantity)   4 begin
  5 :new.onorder := 'T';
  6 end;
  7 /

Trigger created.

SQL> insert into test (quantity, oldquantity)   2 values (1,2);

1 row created.

SQL> select * from test
  2 ;

 QUANTITY OLDQUANTITY O
--------- ----------- -

        1 2

SQL> update test set quantity = 3 where quantity = 1;

1 row updated.

SQL> select * from test;

 QUANTITY OLDQUANTITY O
--------- ----------- -

        3 2 T

---

ops, you mean, you have a column called "oldquantity". Fine, works too:

SQL> drop table test;

Table dropped.

SQL> create table test (quantity number(10),

  2                     oldquantity number(10),
  3                     onorder varchar2(1) );

Table created.

SQL> insert into test (quantity, oldquantity)   2 values (1,2);

1 row created.

SQL> create or replace trigger sample_trigger   2 before update on test
  3 for each row when (new.quantity > new.oldquantity)   4 begin
  5 :new.onorder := 'T' ;
  6 end ;
  7 /

Trigger created.

SQL> update test set quantity = 3 where quantity = 1;

1 row updated.

SQL> select * from test;

 QUANTITY OLDQUANTITY O
--------- ----------- -

        3 2 T

-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net

Received on Tue Mar 23 2004 - 13:59:09 CST