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

Added on Feb 10 2020

#sql-developer

1 comment

466 views