Writting Trigger

From: KonradWo <konrad_at_a.pl>
Date: Tue, 29 Nov 2011 13:30:41 +0100
Message-ID: <4ed4d082$0$1450$65785112_at_news.neostrada.pl>



I have table and i dont know how to write trigger to this table

Table:
CREATE TABLE TAB1
(

  ID      NUMBER(9),
  ID2     VARCHAR2(20)

)

Valuses:

INSERT INTO TAB1 VALUES (1,'')
INSERT INTO TAB1 VALUES (2,'')
INSERT INTO TAB1 VALUES (3,'')
INSERT INTO TAB1 VALUES (4,'')

Single update:
UPDATE TAB1
 SET
ID2 = ('TEXT' || (SELECT ID FROM TAB1 WHERE ID=1))  WHERE ID=1 I have a question:
How to update whole table based on "Single update" ?

I need help with writeing trigger based on "Single update" to automate this process.

I will be very grateful for your help

--------------=  Posted using GrabIt  =----------------
------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- Received on Tue Nov 29 2011 - 06:30:41 CST

Original text of this message