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 -> Help on Query!

Help on Query!

From: Scott <sivaraman55_at_gmail.com>
Date: 25 Oct 2005 18:02:58 -0700
Message-ID: <1130288578.687438.185660@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.
Received on Tue Oct 25 2005 - 20:02:58 CDT












Original text of this message













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