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 operators deal with null?
Differentiate between % rowtype and type record.
How do you take the union of two tables in sql?
Is like operator in sql case sensitive?
What are the advantages of sql?
How to select 10 records from a table?
what are properties of a transaction? : Sql dba
what is the use of friend function? : Sql dba
What is normalization? How many normalization forms are there?
Can sql function call stored procedure?
What is the difference between the conventional and direct path loads? : aql loader
How to combine two stored procedures in sql?
What is a string data type in sql?
How is indexing done in search engines?
how is myisam table stored? : Sql dba