SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Format output - set width of column and also two-lined column name

1001096Apr 5 2013 — edited Apr 6 2013

Hi,

I want column EMPLOYEE_ID to be printed also in two lines and also that the width of the column will be 8 like this:

EMPLOYEE
ID
_______
(width 8)

I tried this:
column EMPLOYEE_ID HEADING EMPLOYEE|ID Format a8

but the two-line formatting didn't work (the width really was 8).

How can I combine this 2 options?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2013

Added on Apr 5 2013

8 comments

13,840 views