Xref: alice comp.databases.oracle.server:83056
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!oleane!proxad.net!feeder2.proxad.net!nnrp2.proxad.net.POSTED!not-for-mail
Message-ID: <3898461E.23FF2FE7@fr.adp.com>
From: Yvan Galas <yvan.galas@fr.adp.com>
Organization: ADP Europe
X-Mailer: Mozilla 4.7 [en] (X11; I; AIX 4.3)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: SQL *Plus screen setup (fonts, display, etc.)
References: <879f4g$eli$1@nnrp1.deja.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 23
Date: Wed, 02 Feb 2000 14:58:22 GMT
X-Complaints-To: abuse@proxad.net
X-Trace: nnrp2.proxad.net 949503502 213.228.23.146 (Wed, 02 Feb 2000 15:58:22 CET)
NNTP-Posting-Date: Wed, 02 Feb 2000 15:58:22 CET

pbshpdrm@my-deja.com wrote:
> 
> How do I change the font in SQL *Plus?  Currently, if a query has
> several columns the results will wrap around which makes it difficult
> for me to read.  If I turn the wrap off the results truncate and I
> cannot see all the results.
> 
> Is it really the font size I want to change or should I also change
> something else?
> 
> Also, is there away to change the number of lines before a query result
> breaks into a new header?  I only want to see the header one time.
> 

Hi,

the commands are : show all for the status of your sqlplus

set linesize XXX
set pagesize XXX

set heading on/off
and so on ....