Home » RDBMS Server » Server Administration » formatting output
formatting output [message #372838] Tue, 13 March 2001 06:18 Go to next message
mb
Messages: 51
Registered: March 2001
Member
Hello

Is it possible to display column names in full when they are wider than the actual column value?
eg.
col1 is varchar2(1) called LongestColNameInTheWorld

so after a select we see

L
--
Y
N

when we want to see

LongestColNameInTheWorld
------------------------
Y
N

Thanks,
Mark

Report message to a moderator

Re: formatting output [message #372842 is a reply to message #372838] Tue, 13 March 2001 08:04 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi

use the sqlplus column format commands

SQL> column LongestColNameInTheWorld format a25

then your query........

Bala

Report message to a moderator

Re: formatting output [message #372846 is a reply to message #372838] Tue, 13 March 2001 11:23 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
As far as I know, the only two default settings for column widths are for Number and Long (NUMWIDTH and LONG). Bala is right that varchar2 columns need to be individually set.

Report message to a moderator

Previous Topic: msaccess sql to ansi sql
Next Topic: Using alias names in group by clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 18:19:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.