Re: how to stop word wrap on sql + worksheet results

From: Geoff Reader <grr_at_NOSPAM.bton.ac.uk>
Date: Wed, 01 Aug 2001 11:49:09 +0100
Message-ID: <3B67DEA4.FCF56D0D@NOSPAM.bton.ac.uk>

Look in the SQLPlus manuals at
set linesize

and columns (particularly formatting)

or if you want to string it all together (eg for a csv) look at concatenation ||

I think that SQLPlus doesn't work in the worksheet (it is after all an SQL worksheet), so only concatenation would help there, but its been a long time since I used it.

Geoff
Geoff Reader
Analyst Programmer
University of Brighton

Mark Rutherford wrote:

> Is there a way to set up sql + worksheet's results page not to wrap the
> results? I would like each row of data to have just one row no matter how
> many columns it has. It should just keep creating a longer row. Or do I
> have to live with it. Both sql + and worksheet do the same thing.
>
> Thanks
>
> Oracle 8i
Received on Wed Aug 01 2001 - 05:49:09 CDT