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
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: 21938
Registered: January 2009
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/
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 334 times)
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: 21938
Registered: January 2009
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.
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
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: 21938
Registered: January 2009
Senior Member
This topic is now locked.
Previous Topic: ODBC numeric settings
Next Topic: Oracle9i Ds Setup cannot start
Goto Forum:
  


Current Time: Thu Apr 17 00:14:03 CDT 2014

Total time taken to generate the page: 0.08908 seconds