Formating column widths with SQLPlus

How do you set column widths to (20 for example) using SQLPlus.Originally posted by rwj7p
How do you set column widths to (20 for example) using SQLPlus.
For a numeric column:
COLUMN colname FORMAT 9999999999.999

For a varchar2 column:
COLUMN colname FORMAT A20

You can also define different default wisth for ALL number columns:

SET NUMWIDTH 20|||Thanks, just what I was needing