Q: control width of DESC

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 18 Nov 2004 15:19:32 -0800
Message-ID: <419d2e04_at_news.victoria.tc.ca>

I am in sqlplus with the following versions, as shown by define

 DEFINE _SQLPLUS_RELEASE = "902000400" (CHAR)

 DEFINE _O_VERSION      = "Oracle9i Enterprise Edition Release 9.2.0.4.0 - 
                           64bit Production With the Partitioning option

I wish to have my LINESIZE set to a large value for displaying data, but when I do this then the DESC command also uses that value, and its output is unreadable.

On a PC I solved this by simply using an older version of SQLPLUS, but I can't do that here.

I have made an sql file wrapper that saves and restores the settings and runs desc, but then I have to remember to type _at_FILE instead of DESC, so in practise I commonly end up having to desc a table twice and losing part of what I was looking at before that.

Are there any other techniques to control the DESC display (other than SET LINESIZE which also control the data display)? Received on Fri Nov 19 2004 - 00:19:32 CET