database Oracle SQLDeveloper 表名自动完成设置
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12578591/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle SQLDeveloper Table Name autocompletion setting
提问by user1683903
I am using Oracle SQLDeveloper 2.1.1.64version. Table Name autocompletion is not happening.
我正在使用Oracle SQLDeveloper 2.1.1.64版本。表名自动完成没有发生。
Checked in autocompletion settings but in vain.
检查自动完成设置但徒劳无功。
Any ideas about it?
关于它的任何想法？
回答by vibs2006
Though this post is old but still I see many people not able to get real Auto Completeintellisense feature because as soon as Auto Complete values exceeds 10then autocomplete doesn't work i.e you need to explicitly use CTRL+SPACEfor displaying intellisense in that case.
虽然这篇文章很旧，但我仍然看到很多人无法获得真正的自动完成智能感知功能，因为一旦自动完成值超过 10，自动完成就不起作用，即在这种情况下你需要明确使用CTRL+SPACE来显示智能感知.
Please follow the steps so that you will be not faced with this problem.
请按照步骤操作，以免遇到此问题。
I'm using SQL Developer 4.2at 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.
在本演示中，我使用的是SQL Developer 4.2。如果您从过去升级到此版本的 SQL Developer 时遇到一些问题，那么您还需要将 JDK 更新到 1.8 或更高版本。
Please follow steps below to ensure that SQL Developer Auto Completion (intellisense) works in ALL cases.
请按照以下步骤确保 SQL Developer 自动完成（智能感知）适用于所有情况。
Step 1:Open SQL Developer and go to Tools -> Preferences
第 1 步：打开 SQL Developer 并转到Tools -> Preferences
Step 2:Select Code Editor -> Completion Insight
第 2 步：选择代码编辑器 -> 完成洞察
Step 3:Ensure that you have following settings as shown in snapshot below
第 3 步：确保您具有以下设置，如下面的快照所示
回答by alfasin
Go to: Tools > Preferences > Code Editor > Completion Insight
And make sure your settings are configured properly:
转到：Tools > Preferences > Code Editor > Completion Insight
并确保您的设置配置正确：
回答by JWK
SQL-Developer probably cannot lookup the completion fast enough on your database and therefore doesn't show it. You can use CTRL-SPACEto try forcing it.
SQL-Developer 可能无法在您的数据库上足够快地查找完成，因此不会显示它。您可以使用CTRL-SPACE来尝试强制它。
回答by user8728052
if nothing works, open a new worksheet. many a times that is the real problem. current worksheet has corrupted
如果没有任何效果，请打开一个新工作表。很多时候这是真正的问题。当前工作表已损坏
回答by rshdev
In my case, Version 18.4.0.376 Build 376.1900, Ctrl-Shift completion was ignored every time I had anyworksheet statements (preceding the one I was trying to complete) that lacked a terminating semicolon or was not commented out.
在我的情况下，版本 18.4.0.376 Build 376.1900，每当我有任何缺少终止分号或未注释掉的工作表语句（在我试图完成的语句之前）时，Ctrl-Shift 完成都会被忽略。
回答by Kas?m ?alda?tan
Tool > Preferences > Editor > AutoReplace check Enabled and Create Definition File. AutoReplace definition file format should be ssf = select * fromand enter one item per line etc. for Version 8.0.1.1498
工具 > 首选项 > 编辑器 > 自动替换选中启用并创建定义文件。 对于版本 8.0.1.1498，自动替换定义文件格式应为ssf = select * from并每行输入一项等
回答by Peter Soxx
CTRL-SPACE works, but only before the intellisense dropdown shows up. I had to increase the time delay before it shows up so that it doesn't show up until after 4 seconds. this way, I have 4 seconds to hit ctrl+space to autocomplete
CTRL-SPACE 有效，但仅在智能感知下拉列表出现之前。我不得不在它出现之前增加时间延迟，以便它在 4 秒后才出现。这样，我有 4 秒的时间按 ctrl+space 来自动完成
