Re: renaming data

Thanks a million, that worked perfectly. Whats a good book that will assist me with query writting. "From the ground up"?

Again thanks for you expertise..

KNez

Matt Brennan wrote:
>
> Can you use decode?:
>
> select decode(mycolumn,'F','First','L','Last,mycolumn) "newcolumnname"f
> from mytable;
>
> "Decode" is a function that does an if, then, if, then, if, then,..., else
> on something.
>
> Above, it means if the value is 'F', then return 'First', if it's 'L', then
> return 'Last', otherwise just return the value for mycolumn (for anything
> that isn't 'F' or 'L').
> --
> Matt Brennan
> SQL*Tools Specialist
> GERS Retail Systems
> 9725-C Scranton Road
> San Diego, California 92121
> 1-800-854-2263
> mbrennan_at_gers.com
> (Original email address is spam-blocked...please change 'net' to 'com'.)
>
> Kyle Nesbitt <greater_at_justviewit.com> wrote in article
> <361A725B.6946D097_at_justviewit.com>...
> > I use Oracle 8, With Platinum's Forest and Trees as a development tool.
> > I am attempting to replace a columns results with an alias identifier.
> > (example: if I get back the letter F in my column then I would like to
> > replace them all with the word FIRST and L with the word LAST and so on)
> > there will be many instances of L's and F's along with about 10 other
> > letter Identifiers.
> > In Forest and Trees I can use an IFVAL
> > function in the Select statement. But, if there are more than one
> > grouup of letters it creates a new column for each. Then I have to go
> > through a bunch of hastle to joint all data back into a single colums..
> > Any suggestions.. Maybe Oracle could return what I need through the SQL
> > statement.
> >
> > Thanks
> >
> >
Received on Tue Oct 06 1998 - 19:12:14 CDT