Re: doing data conversions

If I use this syntax i get what I want displayed, how do you actually write this to update the column?

select state, decode (state,'ID','Indiana','PA','Pennsylvania') from user /

Thanks!!

In article <989502911.131927_at_sleeper.capgemini.nl>, Patrick Sinke says...
>
>It's gonna be a large piece of code, but you can do it with Decode!
>
>select decode( 'AL', 'alabama'
> , 'CA', 'California'
> , ...... -- and so on
> , 'Unknown' -- value if none of the above match
> )
>from table
>
>Also, you could write a function that looks up the code and returns the
>description in a table.
>
>This function has to be placed in a package then, and given a PRAGMA
>RESTRICT REFERENCES( function_name, WNDS, WNPS )
>
>select package.function( 'abbreviation' )
>from table;
>
>
>Good luck!
>
>Regards,
>
>Patrick Sinke
>Cap Gemini Ernst & Young, sector Financial Services.
>
>
>jayzhee <nospam_at_newsranger.com> schreef in berichtnieuws
>8_vK6.817$bi2.63683_at_www.newsranger.com...
>> Hello all. I am looking for a little point in the right direction with
 data
>> conversions.
>>
>> I have a column that has state abbreviations (GA). I need to convert them
 to
>> the full name. Can regular SQL do this? Not sure if I somehow have to
 loop
>> through the rows and use if/then/else logic.
>>
>> Tks
>>
>> jz
>>
>>
>
>
Received on Thu May 10 2001 - 09:03:28 CDT