|
Home > Archive > Tools for Oracle database > January 2006 > Reports 2.5
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| michael.brohan@esb.ie 2006-01-10, 11:23 am |
| Hi,
I have a query. I have a field on a summary report which is
abbreviated i.e. New, Aft etc.
I want to create another field which will give the full description
i.e. New => New Tyres, Aft = Breakdown after hours etc.
how is this done? I've done it before but can't remember?
Any help appreciated
Michael
| |
| DA Morgan 2006-01-10, 11:23 am |
| michael.brohan@esb.ie wrote:
> Hi,
>
> I have a query. I have a field on a summary report which is
> abbreviated i.e. New, Aft etc.
>
> I want to create another field which will give the full description
> i.e. New => New Tyres, Aft = Breakdown after hours etc.
>
> how is this done? I've done it before but can't remember?
>
> Any help appreciated
>
> Michael
One way is with DECODE.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
| Mark C. Stock 2006-01-10, 1:23 pm |
|
"DA Morgan" <damorgan@psoug.org> wrote in message
news:1136911657.989502@jetspin.drizzle.com...
> michael.brohan@esb.ie wrote:
>
> One way is with DECODE.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@x.washington.edu
> (replace x with u to respond)
decode? acchhhhh!
lookup table (code table)
++ mcs
|
|
|
|
|