RE: Sql question

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