Home » Other » Client Tools » Inserting a row into different table than supposed
Inserting a row into different table than supposed [message #38657] Sat, 04 May 2002 03:23 Go to next message
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
Re: Inserting a row into different table than supposed [message #38685 is a reply to message #38657] Mon, 06 May 2002 05:26 Go to previous messageGo to next message
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.
Re: Inserting a row into different table than supposed [message #38709 is a reply to message #38657] Tue, 07 May 2002 21:44 Go to previous message
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
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:
  


Current Time: Thu Mar 28 10:20:47 CDT 2024