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;