SQL*Plus (MOSC)

MOSC Banner

How do you control the length of the column heading?

edited Jul 30, 2012 11:27AM in SQL*Plus (MOSC) 11 commentsAnswered
Hello,

I'm creating an ad-hoc report.  I having problems getting a column heading to be the same size as the reported date.  In the same code and output below, I want the column, "programz", to be the same length as the field name, 'program', which I've truncated (to 42 characters) using the 'substr' function.  I'm using the column command thinking this will control the length of the column heading.  As you can see the output is not behaving as I would want.  What am I doing wrong?  Thank you.

SQL> set linesize 100
set pagesize 40
ttitle 'Sample report title'
column programx format a42

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