Interested to Buy Any Domain ? << Click Here >> for more details...
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
- 4 Answers
- 10730 Views
- Saama Tech, TCS, I also Faced
- E-Mail Answers
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 are the properties of a transaction?
What is PL/SQL Records?
What is parameter substitution in sql?
What is use of term?
What is a database? Explain
Does sql full backup truncate logs?
What are the different types of tables in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What pl/sql package consists of?
what is a materialized view? : Sql dba
What is index example?
Is sql easier than java?
What are two statement types in sql?
Can there be 2 primary keys in a table?
Why do you partition data?
