Home » SQL & PL/SQL » Client Tools » column heading (oracle 10.2.0.3)
column heading [message #468993] Mon, 02 August 2010 22:11 Go to next message
pointers
Messages: 345
Registered: May 2008
Senior Member
Hi,

Can you please help me, how to dispaly the column heading.

I tried to do the below.


03-AUG-10> set pages 0
03-AUG-10> set heading on
03-AUG-10> select count(*) numberofrows
 2    from iceberg_mig_acnts_stage2 s2, tvp109workorder t109
  3   where s2.no_account = t109.no_account
  4     and s2.no_property = t109.no_property
  5     and s2.no_legal_entity = t109.no_legal_entity
  6     and T109.ST_WORK_ORDER <> 'CA'
  7     and T109.IND_WORK_COMPLETED <> 'Y'
  8     and t109.tp_work_order in ('AB','AA','AN','OF','DN','DU',
  9     'IN','MC','MS','NC','ON','RC','SR')
 10     and t109.st_work_order in ('OP', 'PR', 'W ');
           0


Regards,
Pointers
Re: column heading [message #468997 is a reply to message #468993] Mon, 02 August 2010 22:24 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ind> select 'SRIRAM' FIRST,'MICHEL' SECOND,'BLACKSWAN' THIRD from dual;

FIRST  SECOND THIRD
------ ------ ---------
SRIRAM MICHEL BLACKSWAN

1 row selected.

ind> set pages 0
ind> select 'SRIRAM' FIRST,'MICHEL' SECOND,'BLACKSWAN' THIRD from dual;
SRIRAM MICHEL BLACKSWAN

1 row selected.

so remove this Quote:
set pages 0
Smile
sriram

Re: column heading [message #468999 is a reply to message #468997] Mon, 02 August 2010 22:28 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Sriram After Setting "set heading off" Still Columns Heading are not Shown..
Re: column heading [message #469000 is a reply to message #468999] Mon, 02 August 2010 22:31 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
how to dispaly the column heading.
03-AUG-10> set pages 0
03-AUG-10> set heading on


so that's irrelevant here


sriram
Re: column heading [message #469002 is a reply to message #469000] Mon, 02 August 2010 22:36 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Oh Ok , but set heading off Should Work Right ?
Re: column heading [message #469003 is a reply to message #469002] Mon, 02 August 2010 22:38 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
rahulvb wrote on Tue, 03 August 2010 09:06
Oh Ok , but set heading off Should Work Right ?


No, OP wants to display the heading.set heading off wont show the headings.

sriram
Re: column heading [message #469004 is a reply to message #469003] Mon, 02 August 2010 22:41 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Yes, My bad there its Opposite.
Re: column heading [message #469005 is a reply to message #469004] Mon, 02 August 2010 23:02 Go to previous messageGo to next message
pointers
Messages: 345
Registered: May 2008
Senior Member
Hi Ram,

Thats really new to me and helped me a lot.
Thanks a lot.

Do you know why
set pages 0
supress column heading (if any specifice reason) except sql*plus default behaviour

Regards,
Pointers
Re: column heading [message #469030 is a reply to message #469005] Tue, 03 August 2010 01:15 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is all in the documentation.
Re: column heading [message #469140 is a reply to message #469030] Tue, 03 August 2010 09:02 Go to previous message
pointers
Messages: 345
Registered: May 2008
Senior Member
Thanks....
Previous Topic: Removing final carriage return from spooled output
Next Topic: Problem with floating point values
Goto Forum:
  


Current Time: Wed Jul 30 11:28:47 CDT 2014

Total time taken to generate the page: 0.65021 seconds