Oracle SQLDeveloper Table Name autocompletion setting

database oracle-sqldeveloper
user1683903 picture user1683903 · Sep 25, 2012 · Viewed 85.4k times · Source

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?

Answer

vibs2006 picture vibs2006 · Jan 25, 2017

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

Snapshot for Enabling Auto Code Completion

Related questions

How to enter special characters like "&" in oracle database?

I want to insert special character & in my insert statement. My insert is: INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run this query I am getting a popup and it …

Read More
Oracle TNS names not showing when adding new connection to SQL Developer

I'm trying to connect to an oracle database with SQL Developer. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin I'm using the following format in tnsnames.ora: dev = (DESCRIPTION = (…

Read More
Vendor code 17002 to connect to SQLDeveloper

I'm trying to connect to a database using SQLDeveloper and I get the following error: An Error was Encountered performing The requested operation: IO Error: Conection reset Vendor code 17002. Could you please help me?

Read More