Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Column formatting Problem

Re: Column formatting Problem

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 7 Dec 2006 17:37:22 +0100
Message-ID: <45784346$0$11579$426a74cc@news.free.fr>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US