Re: SQLPLUS: how to make results appear in a line fashion

>AleX <korrozia_at_my-deja.com> news:7niumh$83u$1_at_nnrp1.deja.com asked:
>> 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!

[snip]
On Tue, 27 Jul 1999 12:22:24 +0900, "Kyoungrok, Lee" <tunnel_at_hanmail.net> answered:
>Make a view.
>
>create or replace view view_name
>as select col2 from joe where col2 = '2'
>union
> ...
>select col2 from joe where col2 = 'zxz';

This solution assumes the user knows the contents of the columns. In the general case, that would not be true.

hlh_NOSPAM_at_excite.com is a valid, unmunged address! It is also so full of spam(!) that I don't read it. Received on Tue Jul 27 1999 - 08:50:46 CDT