RE: Sql question

  • From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 19 Oct 2004 18:23:32 -0700

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



--
//www.freelists.org/webpage/oracle-l

Other related posts: