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

    Completion Insight Doesn't Seem to Recognize Aliases

    BobbyJ

      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;