General Options Page

The General Options page includes various settings that control how Oracle Developer Tools behaves.

Accessing General Options Page

To access the General Options Page, select Options... from the Tools menu. From the Options menu, select Oracle Developer Tools. Then select General Options.

Using the General Options Setting

The controls of the General Options are as follows:

Control Description

Display Row Numbers

When enabled, the Data Window and the Query Window include row numbers when displaying data.

Limit the SQL Results to:

When enabled, the Data Window limits results to the number of rows entered into the text box.

Add connection to Server Explorer for a New Pluggable Database

When enabled, creating a new pluggable database (see New Pluggable Database Dialog) results in a connection being added to Server Explorer for that pluggable database. If a TNS alias is used to connect to the container database, a new entry for the pluggable database is added to the tnsnames.ora file. If EZ connect is used to connect to the container, then EZ connect is used to connect to the pluggable database. This is only available in Oracle Database 12.1 or later.

Include Schema Name for the connected user

When this is enabled, SQL scripts generated through Server Explorer menus will include the schema name of objects that are owned by the user connected in Server Explorer. This does not apply to Schema Compare nor Oracle Database Project Version 2 script generation.

Include Schema Name for non-connected users

When this is enabled, SQL scripts generated through Server Explorer menus will include the schema name of objects that are not owned by the user connected in Server Explorer. This does not apply to Schema Compare nor Oracle Database Project Version 2 script generation.