Re: Setting default column width in SQLPLUS session

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 07 Feb 2003 18:56:48 +0100
Message-ID: <2qs74vckao88a1evhplja3u50jvnh5410h@4ax.com>

On Fri, 07 Feb 2003 09:12:11 -0800, Bigus Dickus <no_spam_for_me_thanks_at_yahoo.com> wrote:

>I currently set the following parameters when I run sqlplus:
>
>set linesize 164;
>set pause on;
>set pause more;
>set pagesize 50;
>set numwidth 9;
>
>I would also like to set a default column width, for display purposes,
>so that I get the first x characters in fields that are really huge.
>How would I do this?
>

Goto http://tahiti.oracle.com and get to the sql*plus reference manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 07 2003 - 11:56:48 CST