Search notes:

SQL Developer: Tools -> Preferences -> Database -> Worksheet

Options that can be set under the SQL Developer menu Tools -> Preferences -> Database -> Worksheet are
Option Comment
Open a Worksheet on connect
New Worksheet to use unshared connection see below
Close all worksheets on disconnect
Prompt for Save file on close
Grid in checkar board or Zebra pattern
Max Rows to print in a script (Compare with the option Filename for connection startup script, found under Tools -> Preferences -> Database)
Max lines in Script output
SQL History Limit
Select default path to look for scripts Specifiy location where to look for scripts to be executed with @scriptName.sql. Has no bearing on directories when opening or saving files. Stored in product-preferences.xml
Save Bind variables to disk on exit
Show query results in tew tabs
Re-initialize on script exit command

New Worksheet to use unshared connection

This option is required to allow multiple sessions for the same «connection specification» and thus to execute queries in parallel, each on in their separate tab.
The value of this setting is stored in under the user information directory in SystemV.W.X.Y.Z/o.sqldeveloper/product-preferences.xml

Index