|
|
|
|
|
|
|
Re: changing zero into hi? [message #264383 is a reply to message #264379] |
Mon, 03 September 2007 02:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tondapi
Messages: 99 Registered: August 2007 Location: usa
|
Member |
|
|
By using decode function it showing error,THE ERROR IS
EXPRESSION TYPE IS NOT COMPATIBLE WITH THE OBJECT TYPE
The function i used
select decode(loc,0,'hi',loc) from tablename
|
|
|
|
|
|
|
|
|
|
|
|
Re: changing zero into hi? [message #264408 is a reply to message #264402] |
Mon, 03 September 2007 03:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68659 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Michel , my question was about decode one not any other else.
|
I was not answering to you but anyway this seems to work or not, 'Hi' is not a number, a number is not a string, never rely on an implicit conversion, always use same datatype at same place.
Regards
Michel
|
|
|