Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove username from table names in SQL Worksheet

b7ca3201-4486-40c0-99e6-9b5d1364c134Feb 10 2020 — edited Feb 11 2020

I'm needing to hide or remove the feature that adds the database username before the table name in SQL Worksheets.  For example, when using Query Builder in v19.4.0.354 to link tables, it causes table names and columns to be prefixed with the connected database username.  Example,

SELECT  DBUSERNAME.TABLE.COLUMN FROM DBUSERNAME.TABLE;

Is there a preference to turn this off?  I did not experience this setting in v4.0.3.16.

Thanks,

Seth

Comments

Peter de Vaal

This is indeed behaviour that is not desirable when no option is available to switch it off.

I usually build SQL statements by dragging the table from the browser onto the worksheet, then the table name is not prefixed with the schema name.

1 - 1

Post Details

Added on Feb 10 2020
1 comment
382 views