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
)
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