If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
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
How does pl sql work?
explain the difference between bool, tinyint and bit. : Sql dba
what are the join types in tsql? : Transact sql
can a stored procedure call itself or recursive stored procedure? : Sql dba
How does a self join work?
What are all different types of collation sensitivity?
what is error ora-03113: end-of-file on communication channel?
What is meant by <> in sql?
what are date and time data types? : Sql dba
Which table is left in left join?
What is the purpose of the primary key?
How to read/write files from pl/sql?
what is a database transaction? : Sql dba
what is a stored procedure? : Sql dba
How to add a column ‘salary’ to a table employee_details?