"Scott" <sivaraman55_at_gmail.com> wrote in message
news:1130288578.687438.185660_at_o13g2000cwo.googlegroups.com...
> 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.
>
Look up case or decode in the docs. (otn.oracle.com, go to documentation,
sql reference guide, look in the table of contents and look at the
functions.)
Jim
Received on Tue Oct 25 2005 - 21:30:06 CDT
