output lines for a select query [message #422949] |
Mon, 21 September 2009 07:05  |
chandu_imax
Messages: 46 Registered: May 2008 Location: Hyderabad
|
Member |
|
|
Hi All
When we run any of the sql query, It will display 8 lines, after that it will display another 8 lines and so on...
But i want that the query should give the output continuously. We can get it if we set heading off.
Apart from that is there any other way to get 100 lines per heading like that ?
Please suggest me. Suppose we will take an example:
SQL> select * from XYZ;
BANK
--------
SCB
HSBC
TAIB
BBB0
OTH
BILL
BIBD
12457
a
a
BANK
--------
hi
j
a
1
1
2
qaqa
as
1
BANK
--------
hai
sadf
a
sad
HI
hd
as
BANK
-------
i
p
zaq
c
h
a
n
q
a
x
43 rows selected.
Above will be the output. But i require like below.
BANK
--------
SCB
HSBC
TAIB
BBB0
OTH
BILL
BIBD
12457
a
a
hi
j
a
1
1
2
qaqa
as
1
hai
sadf
a
sad
HI
hd
as
i
p
zaq
c
h
a
n
q
a
x
43 rows selected.
Thanks in advance....
|
|
|
|
|
|
|
|