SQLPLUS: how to make results appear in a line fashion

From: AleX <korrozia_at_my-deja.com>
Date: Tue, 27 Jul 1999 00:32:17 GMT
Message-ID: <7niumh$83u$1@nnrp1.deja.com>

 Hi!

I need to have this done.

I'm in sqlplus 8.0.5

I have a query like this:

FLO> select col2 from joe;

COL2

---

2
xzc
ccxc
cxcx
xcx
zxz

6 rows selected.

Is there a way to make the results appear like this

FLO> select col2 from joe;

COL2

---

2, xzc, ccxc, cxcx, xcx, zxz

6 rows selected.

Any help is appreciated!

--

                 Alex Shterenberg

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 26 1999 - 19:32:17 CDT