sqlplus column format
Hello,
When we query vıa sqlplus, records are not readable due to the big column format.
setting smaller value is a way to overcome this.
However, when we have many columns, doing this one by one for each columns is tedious.
İs there way or a command setting all column format to a certaiın value ?
SQL> select * from SA$LEVELS;
POL# LEVEL# CODE
---------- ---------- ------------------------------
NAME
--------------------------------------------------------------------------------
0 1000 DEFAULT
DEFAULT
column code format a40
POL# LEVEL# CODE NAME
---------- ---------- ---------------------------------------- ----------------------------------------
0 1000 DEFAULT DEFAULT