If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
- 4 Answers
- 9208 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
What is sap sql anywhere?
What is difference between db2 and sql?
How do I get sql certification?
What is fmtonly in sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What are the types of dbms?
How do I enable sql encryption?
what is the functionality of the function htmlentities? : Sql dba
Which join is like an inner join?
Which is faster count (*) or count 1?
What are basic techniques of indexing?
What are the main features of cursor?
Why do we use subquery?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is the full form of sql?
