Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Column formatting Problem
<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
Received on Thu Dec 07 2006 - 10:37:22 CST