sql - Oracle result skips row if field exceeds column dimensions -

i have query returns amplifying information subject. fit on 4:3 display monitor, have limited linesize 138, , amplify field has character limit of 30. frequently, long comments ~90-120 characters long.

it fine spills on next row, seems add carriage return causes blank line between , next result. making hard visually keep groups together, there way make not skip line?

assuming you're using sql*plus, can do:

set recsep off 

from documentation:

recsep tells sql*plus make record separation.

for example, if set recsep wrapped, sql*plus prints record separator after wrapped lines. if set recsep each, sql*plus prints record separator following every row. if set recsep off, sql*plus not print record separator.

you're seeing default wrapped behaviour, because long line being wrapped. setting off stops line being added.