Command or Script to Make All Cols 10 chars wide in SQL*PLUS

[sxschech]

Is there a command or script to set the display of all cols in a select statement to 10 chars so that cols that are more than that are truncated? I know that I can change a particular cols, width, but was hoping there is an easy way to do it for all cols without having to specify each one.

 

[SantaMufasa]

Yes, sxschech, it's rather weird that if Oracle SQL*Plus has a

set numwidth 10

(which is the default value), that Oracle SQL*Plus does not have a counterpart "set charwidth 10" command.

Sorry.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Welshbird]

I'm not even sure if this is possible - but could this possibly work in a view?

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]