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.

<koorisatheesh@gmail.com> a écrit dans le message de news: 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.
|

No.

Regards
Michel Cadot

Michel Cadot wrote:

> <koorisatheesh@gmail.com> a écrit dans le message de news: 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.
> |
>
> 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