OraFAQ Forum: Windows » Freezing Column Heading Using PLSQL

Home » Infrastructure » Windows » Freezing Column Heading Using PLSQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Freezing Column Heading Using PLSQL [message #440247]

Thu, 21 January 2010 16:09

syed.nayeem316
Messages: 21
Registered: December 2009
Location: US

Junior Member

Hey,

I have a requirement to freeze the column heading of the execl report.

Can any one help me with this one.

Thanks
Nayeem

Report message to a moderator

Re: Freezing Column Heading Using PLSQL [message #440249 is a reply to message #440247]

Thu, 21 January 2010 16:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have a requirement to freeze the column heading of the execl report.

What does "freeze the column heading of the execl report" mean?

What does this have to do with Oracle?

Perhaps you should ask this in an Excel forum.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Freezing Column Heading Using PLSQL [message #440252 is a reply to message #440249]

Thu, 21 January 2010 16:32

syed.nayeem316
Messages: 21
Registered: December 2009
Location: US

Junior Member

Hey BlackSwan,

Thank You for a quick response.

I have generated a excel report using PL_SQL( Please find the code attach).
I have a requirement to "Freeze the Column Heading in Excel".

Freezing Column Heading means. When you scroll down the rows on execl you should still be able to see the column heading even after scrolling to the last row.

Please let me know if you have further doubts on this.

Thanks
Nayeem

Attachment: 123.txt
(Size: 3.96KB, Downloaded 3000 times)

Report message to a moderator

Re: Freezing Column Heading Using PLSQL [message #440253 is a reply to message #440252]

Thu, 21 January 2010 16:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Freezing Column Heading means. When you scroll down the rows on execl you should still be able to see the column heading even after scrolling to the last row.

This problem has NOTHING! to do with Oracle.
I suggest you post this in some Excel forum.

Report message to a moderator

Re: Freezing Column Heading Using PLSQL [message #440256 is a reply to message #440253]

Thu, 21 January 2010 16:42

syed.nayeem316
Messages: 21
Registered: December 2009
Location: US

Junior Member

Hey BlackSwan,

There is no problem in generating excel report using Plsql.

As you know there is a way to generate excel report using plsql . I am sure ther should be some kind of utility available to Free Column heading in Excel Report.

Thanks
Nayeem Syed

Report message to a moderator

Re: Freezing Column Heading Using PLSQL [message #440257 is a reply to message #440256]

Thu, 21 January 2010 16:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

This topic is now locked.

Report message to a moderator

Previous Topic:	ODBC numeric settings
Next Topic:	Oracle9i Ds Setup cannot start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 16 19:59:36 CDT 2026