Menu
I am using Oracle SQLDeveloper 2.1.1.64 version. Table Name autocompletion is not happening.
Checked in autocompletion settings but in vain.
Any ideas about it?
289
Change autocomplete settings in SQL Developer so that suggestions pop-up automatically more often. By default autocomplete will automatically pop-up only if it finds less than ten suggestions to display or if forced to display by pressing CTRL + space .
Make sure it's enabled in Preferences - Code Editor - Completion Insight and/or use CTRL-SPACE to invoke it manually.
Please follow steps below to ensure that SQL Developer Auto Completion (intellisense) works in ALL cases. @Toolkit have you tried pressing CTRL+SPACE ? If still doesn't show up on pressing this key combination then it won't show by changing the setting as well.
When using the code completion feature, SQL Developer will look at what you've typed so far, and will offer to 'auto complete' what you have at your cursor.
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
131
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
