5 Replies Latest reply on Aug 13, 2015 1:28 PM by thatJeffSmith-Oracle

    Completion Insight Doesn't Seem to Recognize Aliases


      I am new to SQL Developer. I am using 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;