Though this post is old but still I see many people not able to get real Auto Complete intellisense feature because as soon as Auto Complete values exceeds 10 then autocomplete doesn’t work i.e you need to explicitly use CTRL+SPACE for displaying intellisense in that case.
Please follow the steps so that you will be not faced with this problem.
I’m using SQL Developer 4.2 at time of this demo. If you have some issues in upgrading to this version of SQL Developer from the past then you need to also update your JDK to 1.8 or above.
Please follow steps below to ensure that SQL Developer Auto Completion (intellisense) works in ALL cases.
Step 1: Open SQL Developer and go to Tools -> Preferences
Step 2: Select Code Editor -> Completion Insight
Step 3: Ensure that you have following settings as shown in snapshot below
