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
- 10507 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 the difference between delete and truncate commands?
Write a sql query to get the third highest salary of an employee from employee_table?
what is bcp? When is it used?
What is cursor explain with example?
What is over () in sql?
What do you understand by case manipulation functions?
when MSQL8.0 is in market
How do I start sql from command line?
What is natural join in sql?
how to escape special characters in sql statements? : Sql dba
How do I tune a sql query?
What is online transaction processing (oltp)?
How global cursor can be declare with dynamic trigger ?
what is the difference between join and union? : Sql dba
What is assignment operator in pl sql?
