Oracle Development Technology: col formatting Method

COL command:

It mainly formats the display of columns.

This command has the following options:

COL [UMN] [{column | expr} [option…]

The Option can be the following clause:

ALI [AS] alias

CLE [AR]

FOLD_A [FTER]

FOLD_ B [EFORE]

FOR [MAT] format

HEA [DING] text

JUS [cipher] {L [EFT] | C [ENTER] | C [ENTRE] | R [IGHT]}

LIKE {expr | alias}

NEWL [INE]

NEW_V [ALUE] variable

NOPRI [NT] | PRI [NT]

NUL [L] text

OLD_V [ALUE] variable

ON | OFF

WRA [PPED] | WOR [D_WRAPPED] | TRU [NCATED]

1 ). Change the default Column Title

COLUMN column_name HEADING column_heading -- The experiment failed to change the title command. I don't know what the problem is.

For example:

SQL> select * from dept;

DEPTNO DNAME LOC

-----------------------------------------------

10 ACCOUNTING NEW YORK

SQL> col LOC heading location

SQL> select * from dept;

Deptno dname location

------------------------------------------------

10 ACCOUNTING NEW YORK