Online Documentation for SQL Query for Oracle
Setting registration options
Select the database name from the corresponding drop-down list and specify its alias. The drop-down list is only available if more than one Oracle database are registered in the TNS file. Note: If no database are registered in Oracle Client (DB list is empty in this case), then you need to add registration info manually.
Afterwards you should specify authorization type and authorization settings: User name and Password.
Use server authentication for the login. Server Authentication stores logins and passwords in server and does not depend upon Windows.
Use Windows Integrated Security for the login.
Afterwards you should specify authorization settings: User name and Password.
The default superuser name is 'SYS' (for Oracle 9 and higher) and the default password is 'change_on_install'.
Select the type of connection to be established: Normal (by default), SYSDBA, SYSOPER.
Login prompt before connection
Check this option if you wish to be prompted for authorization information (User name and Password) each time you connect to the database.
Autoconnect on startup
Setting this option enables connection to the database automatically when the application is started.
Enable log of SQL Editor queries
Use this option to enable/disable SQL queries log.
This field is enabled if the Enable log of SQL Editor queries option is selected. Here you can specify the path to the *.sql file where SQL queries are logged.
If necessary, you can return to any of the previous steps using the Back button and make the appropriate changes for the currently registered Oracle database.
When done, click the Finish button to complete the Database registration process and start working with the newly registered database in SQL Query for Oracle.