the following query works perfectly fine when used in Oracle SQL Developer:
SET ECHO OFF
SET FEEDBACK OFF
SET LINES 1000
SET LINESIZE 150
COLUMN URL FORMAT a54
SELECT DISTINCT RPAD (ROUTE.URL, 54) URL
FROM ROUTE
ORDER BY URL ASC;
But when issued in my SQLPlus, for some reason, the result rows are divided into 11-lines blocks:
URL
-------
url-1
url-2
url-3
...
url-11
URL
-------
url-12
url-13
url-14
...
url-22
etc..
Why does it happening? and how can I get the results in one block?
I use SQLPlus 11.2.0.3.0