Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: opposite of oracle decode

Re: opposite of oracle decode

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 5 Oct 2005 18:29:11 -0400
Message-ID: <07adnVKVs7AmztneRVn-ug@comcast.com>

"Adam Sandler" <corn29_at_excite.com> wrote in message news:1128550078.183095.202760_at_g14g2000cwa.googlegroups.com...
> Hello,
>
> New to working with Oracle here and I cannot find the answer to my
> question. I have a table that stores a char e.g., 1, 2, or 3. Those
> chars reflect that statuses of reports. 1 = open, 2 = review, 3 =
> closed. When querying I can use decode so the user sees open, review,
> or closed instead of the less meaningful 1, 2, or 3.
>
> My question is what if I want to write to the DB? If the user is using
> a GUI to interface with the DB and they see open, review, or closed in
> the GUI's list of options, I need to trnaslate open, review, or closed
> into 1, 2, or 3 to get it into the DB.
>
> Is there an encode function? Searching on that didn't help... is there
> something the opposite of "decode"?
>
> P.S. This isn't my DB desgin. It is what I was given to work with.
>
> Thanks!
>

just flip the order of the paramters, no? open = 1, review = 2, etc.

or have the GUI display the word and return the number.

what's your gui?

++ mcs Received on Wed Oct 05 2005 - 17:29:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US