Table 1(u_register) Parent table Name &nb

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

Question Posted / abhishekjaiswal

4 Answers
10509 Views
Saama Tech, TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

explain access control lists. : Sql dba

947

Does a primary key have to be a number?

916

How do you delete a table?

997

What does the base_object_type column shows in the user.triggers data dictionary view?

996

Are pl sql variables case sensitive?

997

What is pl/sql language case sensitive?

1059

Does sql between include endpoints?

952

Are sql database names case sensitive?

935

What is auto increment in sql?

1061

What are secondary keys?

921

What is rownum in sql?

965

What is synonyms?

999

Is left join faster than join?

983

What is the difference between local variables and global variables?

1069

which operator is used in query for pattern matching? : Sql dba

947