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
What is the best free sql database?
How do you copy a table in sql?
What is trigger in pl sql with examples?
Is sql sequential or random?
What is the difference between sql and mysql?
Why is sql*loader direct path so fast?
What is pl/sql table? Why it is used?
What is union and union all keyword in sql and what are their differences?
How can we make an if statement within a select statement?
What is transaction control language (tcl)?
What is a temp table?
What port does sql server use?
What is the use of procedures?
what is error ora-03113: end-of-file on communication channel?
How do I view an execution plan in sql?