Hi,
I am new here and this is my first post.
I am attempting to become more familiar with Oracle SQL Developer and am having issues with the Completion Insight utility. I feel like this should be an easy thing to figure out but can't find the solution.
Version 18.1.0.095
Build 095.1630
Settings:
In tools -- > preferences -- > completion insight: I have everything checked, popup speed lowered to .1 seconds, and suppressed results set to 100.
Issue:
I have a table called entity. In that table is a column called id_number. When I either let the columns self-populate or when I hit cntrl_space, the full list of columns is not displayed. Instead the list ends in an ellipses and I have to click it to then refresh the list to see id_number as an option. Once I hit the ellipses ALL of the missing columns appear (there are multiple columns missing from the full list). Screen shot below (the ellipses I am referring to is at the bottom of the displayed columns):
We have been using PL/SQL Developer. In that software when you attempt the same action, it gives you a pop-up organized by the order in which the columns appear and you can quickly click on the one you want from the table. Screen shot below:
Is there another setting I need to tweak or is this not an option within the software?
Thanks,
Greg Kelly