update to database

[FumacII]

Hi everyone,

Does anyone know how to update several cells in a Oracle 8.0 database at the same time?
I have alot of cells that needs to be updated but it will take me alot of time, doing them one by one.

I know how to do it in mySql but Oracle gets over my head.

Thanx alot for any response

/Fumac

 

[THoey]

It depends on what you are doing. If you are going through a table and updating every occurence of 'ABC' to 'XYZ' it would be something like:

UPDATE MyTable
SET MyField = 'XYZ'
WHERE MyField = 'ABC'

Without more info, that should at least be a start... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[MikeLacey]

Do you mean like this Fumac?

UPDATE MyTable SET
[tab]MyField = 'XYZ',
[tab]MyOtherField = 'DEF'
[tab]WHERE MyKeyField = 'ABC'

Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[FumacII]

No not quite, thank you thoug!
I need to change different type of information.
I have a table with text information on a couple of languages. Now I want to add an other language.
In mySql it would be: update tablename set (field1, field2, field3) values ('value1', 'value2', 'value3') where id = xxxx;
Something like that.

Is it possible to do something like this withe Oracle 8.0?

 

[FumacII]

Hmmm tired as I am this morning i read your message wrong, Mike.
Your answer was right. It was what I needed.
Sorry, and thank you!

/Fumac