SQLDeveloper:执行当前行而不突出显示 [英] SQLDeveloper: execute current line without highlighting

问题描述

在Toad中，无需突出显示它即可轻松执行当前行.假设您有一个这样的工作表:

In Toad one can easily execute current line without highlighting it. Let say, you have a worksheet like this:

select * from item -- cursor here


select * from product

当我单击CTRL+Enter时，我只希望执行光标的那一行.在SQLDeveloper中，如果没有第二行，则CTRL+Enter可以按照我的要求工作.基本上，我想做与此处相同的操作，但是由于某种原因，我找不到我正在使用的SQLDeveloper版本中的Tools -> Preferences -> Window Types -> SQL Window and check "AutoSelect statement":4.0.0.13，构建Build MAIN: 13.80.

When I click on CTRL+Enter I want only the line where the cursor is to be executed. In SQLDeveloper, if there is no second line, CTRL+Enter works as I want. Basically, I want to do the same as described here, but for some reason, I can't find the Tools -> Preferences -> Window Types -> SQL Window and check "AutoSelect statement" in the version of the SQLDeveloper I am using: 4.0.0.13, build Build MAIN: 13.80.

好像是在Oracle SQLDeveloper的4.x中删除了此功能?

Seems like, this functionality is taken out in the 4.x of Oracle SQLDeveloper?

推荐答案

对于那些也想知道同一件事的人，这是您必须要做的.用;结束每个语句，它会起作用.

For those who also wonder about the same thing, here is what you gotta do. End each statement with ; and it works.

select * from item
;

select * from product;

这篇关于SQLDeveloper:执行当前行而不突出显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！