OraFAQ Forum: SQL & PL/SQL » copy the contents from one table to another throug trigger

Home » SQL & PL/SQL » SQL & PL/SQL » copy the contents from one table to another throug trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

copy the contents from one table to another throug trigger [message #235334]

Sat, 05 May 2007 01:56

oradat
Messages: 18
Registered: April 2007

Junior Member

Hello every one
how to write an trigger which would enable me to copy the contents of one table to an another .
eg create table temp(
empno varchar2(5),
name varchar2(40));
create table temp_bakup(
empno varchar2(5),
name varchar2(40);
);

now i want to write an such an trigger that would copy the values while inserting in temp into temp_bak.

Report message to a moderator

Re: copy the contents from one table to another throug trigger [message #235341 is a reply to message #235334]

Sat, 05 May 2007 02:47

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Create Trigger with below option.
1.ALTER INSERT
2.FOR EACH ROW
3.:NEW

http://www.adp-gmbh.ch/ora/sql/create_trigger.html

Regards
Taj

Report message to a moderator

Re: copy the contents from one table to another throug trigger [message #235350 is a reply to message #235334]

Sat, 05 May 2007 04:30

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your final purpose?
It is more than likely that trigger is not the correct way to achieve what you need.

Regards
Michel

Report message to a moderator

Re: copy the contents from one table to another throug trigger [message #235362 is a reply to message #235334]

Sat, 05 May 2007 06:23

brizwanahammad.msc
Messages: 1
Registered: May 2007
Location: kldkifkfkf

Junior Member

Hi
I am rizwan may be the folling code will helps u try it
create table a(roll_num number(5), name varchar2(15));
create table b(st_num number(5), name varchar2(15));
--------------
create or replace trigger tg1
before insert on a for each row
begin
insert into b(st_num,name) values(:new.roll_num,:new.name);
end;
/
check the code by inserting values in to the table 'a' the values
of the a will be inserted in the table 'b'.
/
--regards--
rizwan

Report message to a moderator

Re: copy the contents from one table to another throug trigger [message #235628 is a reply to message #235362]

Mon, 07 May 2007 08:21

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

brizwanahammad.msc wrote on Sat, 05 May 2007 07:23

Hi
I am rizwan may be the folling code will helps u try it

Please translate this sentence into english, or any other language for that matter.

Report message to a moderator

Re: copy the contents from one table to another throug trigger [message #235639 is a reply to message #235362]

Mon, 07 May 2007 09:20

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And format the code.

Regards
Michel

Report message to a moderator

Re: copy the contents from one table to another throug trigger [message #237218 is a reply to message #235362]

Sun, 13 May 2007 09:12

oradat
Messages: 18
Registered: April 2007

Junior Member

Thanks
Mr Rizwan this code really works and the concept
of for each row is also cleared .
pls send email me for ur queries regarding pl/sql.
my email id is zizu9096@gmail.com

Report message to a moderator

Previous Topic:	what Bitand Function ????
Next Topic:	what is hard-coded

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 21:21:07 CST 2024