Home » SQL & PL/SQL » SQL & PL/SQL » Re: update multiple fields
Re: update multiple fields [message #20196] Mon, 06 May 2002 09:41
Remmy
Messages: 1
Registered: May 2002
Junior Member
Hi,

I saw your response to ginger on orafaq.net. It was concerning Multiple updates.

I have a a simmlar problem, but i only need to update certain feilds in a table, and only for certain accounts

So i have put all accounts that need updating in one feild with the correct data.

Table with data to be updated is "table1"
desc table1

custid
name
address

Table to update is "tbl_update"
desc tbl_update
custid
name
address
region

I only need to update name and address for all accounts in table1.

any ideas?
Previous Topic: How to select distinct coloumns??
Next Topic: Simple Question about sql
Goto Forum:
  


Current Time: Sat Apr 20 07:43:38 CDT 2024