Execute in new window option?

[SunDog]

Everybody likes shortcuts, right? I have a SQL Window with any number of queries and PL/SQL blocks and if I execute a long-running procedure then I'm prevented from executing any of the other SQL in the window.
Instead of copying the query, opening a new window, pasting then executing, is it possible to highlight the query and select "Execute in a new (SQL/Test) window" to do this all at once?

 

[Killservice]

Hi,

I use LUA-Plugin
and there a "Function" under menu: Lua->Edit->Selection->SQL-Window
I have the a shortcut and when I select code I push shortcut and I become this code in new SQL-Window and there only "F8" and you have all ok ;-)
and with litle doing you can make your "extension" f

 

[Killservice]

Ok I have it do for you ;-)
if you have this Plugin go to file
.\lua\Edit\main.lua
and search for this text "-- Copy selected text to new SQL window"
then add befor this code

-- Copy selected text to new SQL window and execute it
do
	local function ToSqlWindow()
		local text = IDE.GetSelectedText()

		IDE.CreateWindow(plsql.WindowType.SQL, text)
		
		-- execute
		IDE.Perform(1)
	end

	AddMenu(ToSqlWindow, "&Lua / Edit / Selection / SQL Window execute")
end

and you have all what you wanted!

Gregor

 

[SunDog]

Thanks Gregor! I actually created a ToSqlWindowExecute menu item and by setting my key configuration for it to Ctrl-F8, it's even more than I was hoping for. Very cool.