Home » SQL & PL/SQL » SQL & PL/SQL » untrim column name
untrim column name [message #191146] Tue, 05 September 2006 00:56 Go to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
in sqlplus, how can i stop it from truncating the column name? i've set the linesize but it keeps truncating the header because it is short, example:

on sqlplus i have a column APPLIED (from v$archived_log)

upon select the column displays

APP
---
YES
NO
YES

but i want it to displayed

APPLIED
-------
YES
NO
YES


what should i set? thanks sir/mam =)


got it =)

column format heading =)

[Updated on: Tue, 05 September 2006 00:58]

Report message to a moderator

Re: untrim column name [message #191147 is a reply to message #191146] Tue, 05 September 2006 00:59 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


 in sqlplus use
column applied format a15



regards,
Previous Topic: get the first records in a query
Next Topic: Select results in a single row
Goto Forum:
  


Current Time: Thu Dec 08 08:42:31 CST 2016

Total time taken to generate the page: 0.07185 seconds