SQL Language (MOSC)

MOSC Banner

SQL*Plus report column header truncated when column width is set

edited Sep 29, 2016 5:01AM in SQL Language (MOSC) 9 commentsAnswered

Hello there,

I tried to create a report by using SQL*Plus and run it in an Oracle concurrent program.  The requirement for the report is that all the column width are set (range from 1 to 256 char).  When I do that, the column headers would be truncated if the header width is longer than the column width.  For instance, if the column width is just one character:

COLUMN      RECORD_CODE_M                            FORMAT   A1

Then the result is:

R

---

H

What I need in this example is to show full column header but the column width for data is still 1:

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