Selecting a Default Connection to be used when Opening SQL files

You can select a connection in Oracle Database Explorer to be the default connection. This connection will be used when a SQL file is opened that is not explicitly associated with a connection. For example, when opening folders containing many SQL scripts this will associate the connection with all of them, saving you from having to associate each file with a connection.

To set a connection as default (replacing any existing default connection):

1. Create a connection in Oracle Explorer. See Connecting to Oracle Database.

2. Right click on the connection and choose Set as Default Connection. The icon will change to indicate that the connection is now default.

3. Alternatively, in the connection dialog, check the Set as default connection check box.

4. To unset the default connection (so that there is no default), right click on the connection and choose Unset as Default Connection.