Re: opposite of oracle decode

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 7 Oct 2005 00:59:20 -0700
Message-ID: <1128671960.892755.107380@o13g2000cwo.googlegroups.com>

Adam Sandler wrote:
> Daniel... it wasn't clear... If it was, I wouldn't have asked. In the
> first 3 posts, nobody said "use decode both ways". Yes I'm new to
> Oracle, that's why I was asking the questions. As being new to Oracle,
> I'm not necessarily 100% aware of all the built in functions Oracle
> offers. As far as lack of knowledge goes, whatever man - I hope that
> made you feel better. If you find my questions too elementary for you,
> then simply scroll past. There's really no need to flame me (or anyone
> else for that matter)... unless flaming makes you feel better, unless
> flaming helps you compensate for a lack of parental attention growing
> up or even makes you feel better about your tiny penis. It's real easy
> to be 6'6, 250 from behind the anonymity of a keyboard, but any of the
> above aren't excuses for having bad manners... how much CLEARER CAN
> THAT BE? Just scroll past tough guy.
>
> Thanks to the rest of the group for your help!!!

So to summarise:

* You can convert x to y using DECODE
* There is no reverse-decode function to convert y to x
* because that would be the same function, wouldn't it? DECODE converts

arbitrary expressions to arbitrary expressions. Perhaps you were thinking it only converted strings to numbers and not the other way around?
* Possibly there is more to this question to do with your front-end app.

William Robertson
http://Oracle-WTF.blogspot.com Received on Fri Oct 07 2005 - 02:59:20 CDT