I did get the whole output once but since then it's been like shown above which I find weird!
Any ideas on how to make the whole thing appear, some variables I've tried to set are:
set pagesize 100 (& 500) - no change to the above output !!
set arraysize 100
set feedback off
Your SQL*PLus environment variable LONG is set to low (probably to 80, which is the default), so you get all your long columns truncated to that setted value. Set it to something greater to see the whole contents of a long columns, like:
SQL> set long 2000000000
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?