Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Setting default column width in SQLPLUS session

Setting default column width in SQLPLUS session

From: Bigus Dickus <no_spam_for_me_thanks_at_yahoo.com>
Date: Fri, 07 Feb 2003 09:12:11 -0800
Message-ID: <3E43E8EB.68F2DCF1@yahoo.com>


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? Received on Fri Feb 07 2003 - 11:12:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US