try this
select colA,colB,
decode(UPPER(Colc),'IN','Input Parameter','OUT','Output Parameter')
ColC
from A;
DA Morgan wrote:
> Scott wrote:
> > I have a table A, that has columns,
> >
> > ColA
> > ColB
> > ColC
> >
> > The value is ColC is stored as 'IN' and 'OUT'.
> >
> > How do I write a query that selects 'IN' or 'OUT' and if it is 'IN', it
> > should
> > get displayed as 'Input Parameter' and if 'OUT' it should get displayed
> > as
> > 'Output Parameter'.
> >
> > Thanks in advance.
>
> You ask your instructor for extra help after class.
>
> For all other c.d.o.s. denizens ... I gave my students their midterm
> tonight. It is ... of course ... purely a coincidence ... that these
> requests for queries against tables named emp and A all showed up now.
>
> Please do not give away the answers. Thanks.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Wed Oct 26 2005 - 09:52:03 CDT
