CREATE table trg_tab (ename VARCHAR(10), sal NUMBER); / CREATE table lo

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

Question Posted / anil

4 Answers
10694 Views
Saama Tech, TCS, I also Faced
E-Mail Answers

Answer Posted / anil

CREATE table trg_tab
(ename VARCHAR(10),
sal NUMBER);
/
CREATE table log_tab
(usr VARCHAR(10),
upd DATE,
ename VARCHAR(10),
sal NUMBER
);
/
CREATE OR REPLACE TRIGGER log_trg
AFTER INSERT ON trg_tab
FOR EACH ROW
DECLARE
v_user VARCHAR(10);
BEGIN
SELECT USER
INTO v_user
FROm DUAL;
INSERT INTO log_tab
VALUES (v_user,SYSDATE,:NEW.ename,:NEW.sal);
END;
/
INSERT INTO trg_tab
SELECT ename,sal FROm emp;
/
SELECT * FROm log_tab;
/

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

when MSQL8.0 is in market

2072

What is cursor explain with example?

979

How to convert comma separated string to array in pl/sql?

1173

How do I edit a trigger in sql developer?

990

What is oracle pl sql developer?

978

What is trigger types of trigger?

1065

What is procedure in pl sql?

1039

what is isam? : Sql dba

1001

What are sql ddl commands?

1084

How much does sql cost?

994

What is a pragma statement?

1262

What is the difference between row level and statement level trigger?

1015

How do I run a sql query?

1012

When are we going to use truncate and delete?

981

What is numeric function sql?

1054