Support for SQL*Plus functionality in SQL Developer has gotten better from release to release. In version 4.1 we took a giant leap forward, adding support for many SQL*Plus commands, and coming much closer to emulating script execution behavior.
One example, we added support for BREAK and COMPUTE commands.
Another change was adopting several of the SQL*Plus defaults, including pagesize.
It’s not just the number of rows on a query, you also count blank lines, the column headers, etc.
So querying for 15 rows on a pagesize of 14 gives me more than one page.
This is how SQL Developer version 4.1 will behave now as well.
Changing the Defaults
It’s very easy. You can use the same mechanism that SQL*Plus users have been using for decades – a ‘logon’ SQL script.
Apply preferences. Disconnect. Connect. Open Worksheet, run again.
Some of you don’t like having to toggle on DBMS Output support. So I’ve shown you how to get this output by default. It’s using the same mechanism as above.
Just show me all the settings, so I know what’s what
Ok, use ‘SHOW ALL’
You can change them for your session at any time using the SET command in a worksheet, or you can change them at logon using the script and preference method.