Home » RDBMS Server » Server Administration » Update statement
Update statement [message #372939] Mon, 19 March 2001 13:29 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
How can I update multiple values in a table in one udpate statement.

Ex: Update all occurences of "North West" with "NW'
"North East" with "NE"
"South" with "S"
"North" with "N" etc....

Please Help !!

Thanks!
Alpesh

Report message to a moderator

Re: Update statement ---Urgent !!!! [message #372943 is a reply to message #372939] Mon, 19 March 2001 14:02 Go to previous messageGo to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hi,

Can somebody please help me out with this. It's very urgent !!!!

How can I update multiple values in a table in one udpate statement.
Ex: Update all occurences of "North West" with "NW'
"North East" with "NE"
"South" with "S"
"North" with "N" etc....

Please Help !!

Thanks!

Report message to a moderator

Re: Update statement [message #372957 is a reply to message #372939] Tue, 20 March 2001 03:33 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372958 is a reply to message #372939] Tue, 20 March 2001 03:34 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372959 is a reply to message #372939] Tue, 20 March 2001 03:35 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372960 is a reply to message #372939] Tue, 20 March 2001 03:35 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372961 is a reply to message #372939] Tue, 20 March 2001 03:35 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372962 is a reply to message #372939] Tue, 20 March 2001 03:35 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372963 is a reply to message #372939] Tue, 20 March 2001 03:36 Go to previous messageGo to next message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Re: Update statement [message #372964 is a reply to message #372939] Tue, 20 March 2001 03:37 Go to previous message
kshiva
Messages: 10
Registered: March 2001
Junior Member
Update statement:
By using Decode statement in Update u can update
Ex:-
Update table_name
Set Column =Decode(Column,'North West','NW','North East','NE'..)

shiva

Report message to a moderator

Previous Topic: Oracle Navigator
Next Topic: Sequence in PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 11 09:16:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.