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
- 10703 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
define sql delete statement ? : Sql dba
How to use boolean type in select statement?
What is the difference between a primary key and a unique key?
What is sharding in sql?
what is a trigger? : Sql dba
What are the built in functions of sql?
How do I access sql anywhere database?
How does a trigger work?
What is difference between db2 and sql?
What is string join?
Explain the purpose of %type and %rowtype data types with the example?
Why use subqueries instead of joins?
How is use pl and sql?
Is oracel sql developer written in java?
How do I save a stored procedure?
