OraFAQ Forum: Client Tools » Inserting a row into different table than supposed

Home » Other » Client Tools » Inserting a row into different table than supposed

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

Inserting a row into different table than supposed [message #38657]

Sat, 04 May 2002 03:23

Raghunath.L
Messages: 2
Registered: May 2002

Junior Member

Hi,

I'm new to PL/SQL Programming, Please help in solving the following:

suppose if you are going to insert a row into table 'A'. The new row needs to be inserted into table 'B' instead of table 'A'.

Is it possible, if so how?

Please send me the source code for the same.

Thanking you,
Raghu

Report message to a moderator

Re: Inserting a row into different table than supposed [message #38685 is a reply to message #38657]

Mon, 06 May 2002 05:26

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

I never heard of this type of req. if u want to insert into table B , why dont u issue insert stmt against tableB. if u want to insert row in table B when u insert record in table A then you create insert trigger on table A.

Report message to a moderator

Re: Inserting a row into different table than supposed [message #38709 is a reply to message #38657]

Tue, 07 May 2002 21:44

Raghunath.L
Messages: 2
Registered: May 2002

Junior Member

Thanks Suresh, Could you please send me some sample for the same. I will be very thankful to you for this.

Regards & Thanks,
Raghu

Report message to a moderator

Previous Topic:	user from dual doesn't evaluate against table column
Next Topic:	Is it possible to spool data to to fixed format file?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 29 15:55:33 CDT 2025