CREATE TABLE A1(ID NUMBER(2),NAMES VARCHAR2(30)) CREATE TABLE B1(ID NUMB

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

Question Posted / shwetha

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

Answer Posted / shwetha

CREATE TABLE A1(ID NUMBER(2),NAMES VARCHAR2(30))

CREATE TABLE B1(ID NUMBER(2),NAMES VARCHAR2(30),STATUS VARCHAR2(10))

CREATE OR REPLACE TRIGGER A1B1
AFTER INSERT ON A1
FOR EACH ROW
BEGIN
INSERT INTO B1 VALUES(:NEW.ID, :NEW.NAMES,'Y');
END;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is synonyms?

1118

What is data types in sql?

1070

Write a sql query to find the names of employees that begin with ‘a’?

1057

Can we insert data in view?

1008

What is the difference between partition and index?

1055

what is blob? : Sql dba

1219

What is the current version of postgresql?

1127

what is the command line end user interface - mysql? : Sql dba

1028

Is big data nosql?

1000

Define concurrency control. : Transact sql

1236

What is rank dense_rank and partition in sql?

1085

what are the different functions in sorting an array? : Sql dba

1066

what are the different type of normalization? : Sql dba

1067

Can ddl statements be used in pl/sql?

1192

who introduced sql?

1072