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!

SQL Developer - Describe command with comments bug

lazyman65Mar 23 2016 — edited Mar 24 2016

I'm using SQL Developer 4.1.3.20 (build Main 20.78)

When I enter a describe table command that also contains comments (using either the /* */  or the double dash "--")

SQL Developer seems to be taking the last word in my comments as the item it is trying to describe.

I tried it a few different ways:

1) describe  table_1;   /* child table of table_2 */

RESULT:   ERROR: object */ does not exist

2) describe  table_1;   -- child table of table_2

RESULTS:  It actually does a describe on table_2 instead of table_1 as requested.

3) describe  table_1;   -- my comment table_that_does_not_exist

RESULTS:  ERROR: object TABLE_THAT_DOES_NOT_EXIST does not exist

In all instances the comment text is turned grey as expected, so it seems to be recognizing it as a comment.

I know its a minor issue but was curious if others have same issue?

Curtis.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 20 2016
Added on Mar 23 2016
2 comments
914 views