If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
Answer Posted / abhishekjaiswal
Table 1(u_register) Parent table
Name Null? Type
----------------------------------------- -------- ----------------------
FIRST_NAME VARCHAR2(15)
LAST_NAME NOT NULL VARCHAR2(15)
DOB NOT NULL DATE
USER_NAME NOT NULL VARCHAR2(15)
NEW_PASSWORD NOT NULL VARCHAR2(15)
CONFIRM_PASSWORD NOT NULL VARCHAR2(15)
U_ID NOT NULL NUMBER
table 2(login_detail) Child table
Name Null? Type
----------------------------------------- -------- ----------------------
ID NOT NULL NUMBER
USER_NAME VARCHAR2(15)
NEW_PASSWORD VARCHAR2(15)
Now we will create trigger to insert column 'user_name','new_password' of u_register into column 'USER_NAME ','NEW_PASSWORD' of login_detail.We will use after insert trigger as
create or replace
trigger tgr_login
after insert on u_register
for each row
begin
insert into login_detail
values (:new.u_id,:new.user_name,:new.new_password);
end tgr_login;
It will work for sure.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How delete a row in sql?
Why do we use set serveroutput on?
Why is nosql good?
Explain some predefined exceptions.
What are different categories of sql commands?
what are all the different normalizations? : Sql dba
how can you see all indexes defined for a table? : Sql dba
What is the difference between function, procedure and package in pl/sql?
How do you optimize a stored procedure in sql?
What are the triggers associated with image items?
Does sql full backup truncate logs?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is auto increment feature in sql?
How to use sql statements in pl/sql?
What plvcmt and plvrb does in pl/sql?