Re: Column formatting Problem

Michel Cadot wrote:

> <koorisatheesh_at_gmail.com> a écrit dans le message de news: 1165469455.269495.147280_at_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.
> |
>
> No.
>
> Regards
> Michel Cadot
>
>

While techically correct you can try:

select emplid, cast(empl_status as char(12)) from ....

or

COLUMN empl_status FORMAT A12
select emplid,empl_status from .... ;

depending on how you are intending on using the SQL output.

-- 
Michael Austin.
Database Consultant