Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Column Heading
<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
![]() |
![]() |