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)