How to set the column width of the desc result in sqlplus?

Is t开发者_如何学JAVAhere any way to set the column width of the result of desc command in sqlplus?

Thanks

In general you can't. Describe decides how much horizontal space to take up based on linesize. I asked Tom about how to set the describe width and linesize seperately. Some of the follow up answers have scripts to capture current linesize, change to a shorter linesize to keep the describe results compact, and then restore current linesize.

I believe you need SET LINES XX

However this handy SQL*plus command reference will help :-)

http://ss64.com/ora/syntax-sqlplus-set.html

You can format sqlplus reports in a variety of ways.

What you need here can be mostly achieved by [SET LIN[ESIZE][2]] (you have to scroll down)