How to explain without exactly knowing what has changed and when – but i’ll try.Īfter looking at the result of the “show all” command i’ve found what i meant:Īppinfo is OFF and set to “SQL Developer”Īppinfo ist OFF und auf “SQL Developer” gesetzt 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. SET SERVEROUTPUT ON Just show me all the settings, so I know what’s what So I’ve shown you how to get this output by default.
Some of you don’t like having to toggle on DBMS Output support. Voila! My entire resultset fits on an entire ‘page’ now. This script will be executed whenever SQL Developer creates an Oracle Database connection.Īpply preferences. You can use the same mechanism that SQL*Plus users have been using for decades – a ‘logon’ SQL script.
Don’t like the defaults? Change them! Changing the Defaults This is how SQL Developer version 4.1 will behave now as well. So querying for 15 rows on a pagesize of 14 gives me more than one page. It’s not just the number of rows on a query, you also count blank lines, the column headers, etc. The number of lines to print on a ‘page’ in SQL*Plus Access to these commands and formatting is available when executing one or more statements via F5.Īnother change was adopting several of the SQL*Plus defaults, including pagesize. One example, we added support for BREAK and COMPUTE commands. 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. Support for SQL*Plus functionality in SQL Developer has gotten better from release to release.
0 kommentar(er)
