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!

Completion Insight Doesn't Seem to Recognize Aliases

BobbyJAug 12 2015 — edited Aug 13 2015

I am new to SQL Developer. I am using 4.1.1.19 on Windows 7.  I have used Toad in the past. It doesn't seem as though Completion Insight recognizes the aliases (see example below). I'm sure it must be something I am doing, not the app. I would like for the completion pop-up to display the column names based on the alias that I've started to type as soon as there is a pause. For example, when typing "where i." and then pause, I would like to get a list of the columns from the item table that I could select one by one. This doesn't seem to work for me.

select * from item i, itemparam u

where i.item = u.item;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2015
Added on Aug 12 2015
5 comments
871 views