If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
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
Why is nosql good?
What are the query optimization techniques?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is your daily office routine?
How to avoid duplicate records in a query?
What is offset and limit in sql?
What does <> sql mean?
Differentiate pl/sql and sql?
What is embedded sql what are its advantages?
Can we perform dml on view?
What is the difference between between and in condition operators?
what is the difference difference between procedure and packages
How can I make sql query run faster?
What is sql*plus?
Can we alter stored procedure?