Home » SQL & PL/SQL » Client Tools » Column Names truncated in SQL Plus (9i R2)
Column Names truncated in SQL Plus [message #355881] Tue, 28 October 2008 05:41 Go to next message
galaxy
Messages: 62
Registered: October 2005
Member
Hi,

I have the issue that my SQLPlus is truncating the column headings of my sql statement result.

For Example The full column name is Postal_Code, but my query result looks like (The size of the column is varchar2(5)):

Posta
-----
66898
99785

Can on of you please tell me a function / command to get the full column names back, so no truncated ones?

Thanks in advance for your help,
Regards,
Martin
Re: Column Names truncated in SQL Plus [message #355895 is a reply to message #355881] Tue, 28 October 2008 06:04 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enlarge your column size using SQL*Plus COLUMN statement.

Regards
Michel
Previous Topic: Remote database access through SQLPLUS issue
Next Topic: Query Analyzer tool
Goto Forum:
  


Current Time: Sun Dec 11 04:01:54 CST 2016

Total time taken to generate the page: 0.12089 seconds