本文介绍了SQLDeveloper:执行当前行而不突出显示的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

在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:执行当前行而不突出显示的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-19 01:10