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

Home -> Community -> Usenet -> c.d.o.server -> Re: set head on

Re: set head on

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 22 Oct 2007 06:47:50 +0200
Message-ID: <471c2b75$0$24151$426a74cc@news.free.fr> 






"Jake" <jgarfield_at_earthlink.net> a écrit dans le message de news: 1193016259.363540.207150_at_e34g2000pro.googlegroups.com...


| okay, this may be a dumb question but:

|

| why am I not getting any headers in SQL*Plus?  see output below:

|

| SQL> set head on

| SQL> select * from user_procedures;

| TRAP_ERRCODE                                                  NO  NO


|                                                              NO  NO

| NO

| DEFINER


|

| EMPLOYEEAGE                                                   NO  NO


|                                                              NO  NO

| NO

|

|

| what do I have to do to get the headers above the columns when i do a

| select?

|




Because you have pagesize 0



Regards


Michel Cadot
Received on Sun Oct 21 2007 - 23:47:50 CDT












Original text of this message













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