Home » SQL & PL/SQL » Client Tools » How to remove blank line shown in output (Oralcle 10g , XP)
How to remove blank line shown in output [message #377780] Thu, 25 December 2008 02:30 Go to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hello friends,

When I fire any SELECT query, it gives row by row output.
When this output is too long, it places one blank row after (around 13) records. and there where is the problem.
I want to remove these blank lines.
How is this possible?

I have set HEADING off.
SQL> select table_name from user_tables where table_name like 'TABLE%';

TABLE1
TABLE10
TABLE11
TABLE12
TABLE13
TABLE14
TABLE15
TABLE16
TABLE17
TABLE18
TABLE19
TABLE2
TABLE20

TABLE21
TABLE22
TABLE23
TABLE24
TABLE25
TABLE26
TABLE27
TABLE28
TABLE29
TABLE3
TABLE30
TABLE31
TABLE32

TABLE33
TABLE34
TABLE35

...

TABLE97
TABLE98

98 rows selected.


regards,
Delna
Re: How to remove blank line shown in output [message #377784 is a reply to message #377780] Thu, 25 December 2008 02:37 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
set pagesize 100
Re: How to remove blank line shown in output [message #377793 is a reply to message #377784] Thu, 25 December 2008 03:14 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Oh yes,

I got it.
As default size is 14 lines per page, it was shown like that.
But my output is much more long.
Hence I set page size accordingly.

thanks.

regards,
Delna
Re: How to remove blank line shown in output [message #378923 is a reply to message #377793] Fri, 02 January 2009 12:18 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
it's much safer to "set pagesize 0" than to set to 10000 or whatever.
Previous Topic: How to make Client
Next Topic: installing oracle 9i
Goto Forum:
  


Current Time: Thu Dec 08 14:41:32 CST 2016

Total time taken to generate the page: 0.06282 seconds