Home » Infrastructure » Windows » Freezing Column Heading Using PLSQL
Freezing Column Heading Using PLSQL [message #440247] Thu, 21 January 2010 16:09 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 2858 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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 20 18:50:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.