Formating column widths with SQLPlus

rwj7p · #1 (**permalink**) 11-27-02, 12:28

How do you set column widths to (20 for example) using SQLPlus.

andrewst · #2 (**permalink**) 11-27-02, 12:36

Quote:

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

rwj7p · #3 (**permalink**) 11-27-02, 18:25

Thanks, just what I was needing

Internet Services

Web Development

Digital Marketing

Consumer Tech