SQL DEVELOPER script output formatting

Question

There seems to be a line break after every 11 entries in my script output in SQL developer. How can I get rid of it?

Kobi · Accepted Answer · 2018-04-03 12:55:07Z

4

SQL Developer output use same format as SQL*Plus.

you can use SHOW ALL command to view all availables format setting.

You can try your own fitness by changing PAGESIZE value.

answered Apr 3, 2018 at 12:55

Kobi

2,52418 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Correct. Default pagesize is 11.

set pagesize 0 select line from user_source; -- execute F5 for quick sanity check