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

What is the unique index?

1002

How many parts of a pl sql block are optional?

1031

Does truncate remove indexes?

969

Does truncate require commit?

918

What is the example of procedure?

874

Which query operators in sql is used for pattern matching?

901

Is drop table faster than truncate?

939

how to use myisamchk to check or repair myisam tables? : Sql dba

910

How do I view a sql trace file?

960

What is a scalar value in sql?

1010

What is sql in java?

1025

What is dynamic query?

913

What are the string functions in sql?

922

Can we create view in stored procedure?

908

What are the different types of tables in sql?

928