Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sql question

RE: Sql question

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 19 Oct 2004 18:23:32 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87AC4@irvmbxw02>


Select decode (n1, 'E', 'D', n1) from test1 ;
-----Original Message-----

SRIDHARAN, SAN (SBCSI) Here the output from the table test1

Select * from test1;

N1
---

A
B
C
D
E
F

Is there an Oracle function or is there a Sql statement that will print the following result without us create a function.

Result


A,B,C,D,D,F

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 19 2004 - 20:21:36 CDT

Original text of this message

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