Home » SQL & PL/SQL » SQL & PL/SQL » Bulk Updation (Oracle 9i R 2)
Bulk Updation [message #338638] Tue, 05 August 2008 09:14 Go to next message
uttamkumar
Messages: 2
Registered: July 2008
Location: Chennai
Junior Member

Hi,

I want to update the Field2 of TableA with Field5 of TableB
the joining fields are Field1 of TableA and Field3 of TableB

I have written the query like

Update TableA set TableA.Field2 = TableB.Field4
From TableB where TableA.Field1 = TableB.Field3

Didn't work
Also tryed this.

Update TableA set (TableA.Field2) = select TableB.Field4
From TableB where TableA.Field1 = TableB.Field3)
--Didn't work
also tried this

Update TableA set TableA.Field2 = TableB.Field4
From
(select Field4 from TableB where TableA.Field1 = TableB.Field3)

Can any one help me that what will be the correct query for bulk update?

Regards,
Uttam





Re: Bulk Updation [message #338642 is a reply to message #338638] Tue, 05 August 2008 09:27 Go to previous messageGo to next message
ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD
Senior Member
search on google for Bulk collect,if u want to update a large set of values.Else go again with your queries and try to figure out the problem.If not we will help you out.
Re: Bulk Updation [message #338654 is a reply to message #338638] Tue, 05 August 2008 10:16 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UPDATE

Regards
Michel
Previous Topic: Transaction Logging
Next Topic: column to rows
Goto Forum:
  


Current Time: Tue Dec 06 04:41:03 CST 2016

Total time taken to generate the page: 0.33857 seconds