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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment