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!

[4.0] Can't view tables where column names are reserved words

ArpodJan 31 2014 — edited May 6 2014

If a table contains any column, which name is the same as reserved word (like "level", "index", "connect" etc.), then "Table->Data" tab fails to open with "ORA-00904: <column_name>:invalid identifier" error.

I know that having reserved words as column names is "wrong", but it's way too late to change our design, and it's still a rather serious bug that needs addressing.

I use SQLDev 4.0.0.13.80, Java 1.7.0_45 and our DB is Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 64bit.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2014

Added on Jan 31 2014

#bug, #sql-developer

17 comments

9,651 views