| How to remove blank line shown in output [message #377780] |
Thu, 25 December 2008 02:30  |
 |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
