|
Replies:
4
-
Pages:
1
-
Last Post:
Dec 1, 2011 12:22 AM
by: pstein
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
How to execute only the current SQL statement in editor (not all)?
Posted:
Nov 28, 2011 12:01 AM
|
|
|
In a connected Session I have an opened editor with multiple SQL+DDL statements
(delimited by blank lines).
When I press now F5 then ALL current SQL+DDL statements are executed.
I don't want to do this. I only want to execute the current statement (=the statement on which the cursor is currently placed).
As far as I know there is a way of such a current-statement-only execution.
But how does it work in detail?
Peter
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: How to execute only the current SQL statement in editor (not all)?
Posted:
Nov 29, 2011 9:59 AM
in response to: pstein
|
|
|
Use execute statement instead of execute script (By default bound to F9).
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
Re: How to execute only the current SQL statement in editor (not all)?
Posted:
Nov 30, 2011 5:10 AM
in response to: Mauritz
|
|
|
Thank you, it works when I press F9.
But where exactly do I find the corresponding menu?
I didn't found it
Peter
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: How to execute only the current SQL statement in editor (not all)?
Posted:
Nov 30, 2011 9:32 AM
in response to: pstein
|
|
|
In the default toolbar/menu layout it is the second button on the editor toolbar (Right next to execute script) and the second menu item in the "Editor" menu (Right under execute script).
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
Re: How to execute only the current SQL statement in editor (not all)?
Posted:
Dec 1, 2011 12:22 AM
in response to: pstein
|
|
|
Thank you
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
