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
- 10861 Views
- Saama Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishek jaiswal
Table 1(U_register)
Name Null? Type
----------------------------------------- -------- ----------------------------
FIRST_NAME PK 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)
Name Null? Type
-------------------------FK---------------- -------- ----------------------------
ID NOT NULL NUMBER
USER_NAME VARCHAR2(15)
NEW_PASSWORD VARCHAR2(15)
Now,We have to write trigger to insert of column 'user_name' and 'new_password' in login_detail table.
To do this we will use After insert trigger.
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;
---and It will work .
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is an index? : Sql dba
How can you know that statistics should be updated?
Why self join is used in sql?
What is dialect in sql?
What is snowflake sql?
What is sql and explain its components?
What is the difference between an inner and outer join?
how many groups of data types? : Sql dba
What are triggers and its types?
Can I join the same table twice?
Is left join same as inner join?
What information is needed to connect sql*plus an oracle server?
Explain 3 basic parts of a trigger.
What is %rowtype in pl sql?
how do you know if your mysql server is alive? : Sql dba
