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: SQL Column Heading

Re: SQL Column Heading

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 7 Feb 2006 07:07:44 +0100
Message-ID: <43e8392e$0$4773$636a55ce@news.free.fr>

<mohd.shihabuddin_at_gmail.com> a écrit dans le message de news: 1139278513.066333.211900_at_g14g2000cwa.googlegroups.com...
| Hi guys,
|
| When we execute a select stmt in sqlplus we don't get the column
| headings full , it is shown according to the data in that column.
| So, i want to display the column headings in full as it was mentioned ,
| while creating the table.
| Can tell by setting which parameter of column , it will show me the
| full column heading.
|
|
|
| Now,
| Eg:- select employee_nmbr,employee_name from emp;
|
| emplo emp
| -------- ------
| 1 KP
|
| I want,
|
| Eg:- select employee_nmbr,employee_name from emp;
|
| employee_nmbr employee_name
| ----------------------- ------------------------
| 1 KP
|
| Just chk the column headings in both the SQL stmts, I want the output
| as it is in the 2nd eg.
|
| Is there a single command to set this behavious universally so that i
| dont have to user 'format' command for all column.
|

You have to use "col ... format ..." statement for each column.

Regards
Michel Cadot Received on Tue Feb 07 2006 - 00:07:44 CST

Original text of this message

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