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 |
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. |