SQL*Plus (MOSC)

MOSC Banner

sqlplus column format

edited Apr 11, 2017 6:48AM in SQL*Plus (MOSC) 13 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center