Home » SQL & PL/SQL » SQL & PL/SQL » Printing the spooled file (ORacle 9i)
Printing the spooled file [message #320069] Wed, 14 May 2008 00:31 Go to next message
senaubi_me
Messages: 24
Registered: February 2008
Junior Member
Hi All,

I need some help on printing the spooled file in an A4 size paper(landscape). I have an sql which query for several columns the total linesize i used is about 350 character, how ever when i try to print this to an A4 size paper the printed file is wrapped.
I need to shorten the length of the columns to be able to fit the columns in one row. I dont know what is the exact line size for an A4 size pare to fit the columns.

Appreciate any help from you guys.

Thank You.
Jen
Re: Printing the spooled file [message #320072 is a reply to message #320069] Wed, 14 May 2008 00:41 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
So, what's your question?
Surely you would not go to an Oracle forum to ask how many characters fit on a landscape A4 sheet?
Re: Printing the spooled file [message #320074 is a reply to message #320069] Wed, 14 May 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I dont know what is the exact line size for an A4 size

It depends on your font type and size.
Use notepad and make some tests.

Regards
Michel
Re: Printing the spooled file [message #320122 is a reply to message #320069] Wed, 14 May 2008 02:39 Go to previous messageGo to next message
senaubi_me
Messages: 24
Registered: February 2008
Junior Member
Hi,

Thank you for the reply.

I have made some testing and i think it is less than 200. However is there any documentation that tells any limitation on setting the line size. For example what is the minumun linesize to be defined or maximum.

Re: Printing the spooled file [message #320124 is a reply to message #320122] Wed, 14 May 2008 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> set linesize 1000000
SP2-0267: linesize option 1000000 out of range (1 through 32767)

So max for SQL*Plus is 32767.

Regards
Michel

Re: Printing the spooled file [message #320128 is a reply to message #320069] Wed, 14 May 2008 02:51 Go to previous message
senaubi_me
Messages: 24
Registered: February 2008
Junior Member
Thank's for the reply.
Previous Topic: Problem in executing sql query
Next Topic: doubt on joins
Goto Forum:
  


Current Time: Fri Dec 09 15:30:40 CST 2016

Total time taken to generate the page: 0.15893 seconds