Column formatting Problem

From: <koorisatheesh_at_gmail.com>
Date: 6 Dec 2006 21:30:55 -0800
Message-ID: <1165469455.269495.147280@n67g2000cwd.googlegroups.com>

I am facing a Problem here..

For example , The Value of empl_status in job table is one character ( Active - A, teminated - T )

Here comes the problem....when I run the same SQL in Oracle .. i am getting

emplid e

---

xxxxxxx A

Here , for the Empl_status , I am getting only the E as heading..What I need is to display the Column empl_status without truncating.......

There is command called Set linesize .. But this doesnot help in this..  It will only display all columns in single line and nothinig to do with column width..

Also, we have a command column <col_name> format... this is very specific..

do we have anything to do with settings and make it as generic ? so that the column names are not truncated. Received on Wed Dec 06 2006 - 23:30:55 CST