Format instead of execute
"John Graves" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Maybe someone can suggest what is going on here. In the editor I have this:
CURSOR c1 IS SELECT dummy FROM dual;
If I highlight SELECT through ; or SELECT through dual and press F9, I
get the expected output.
If I go up two lines and put in a DECLARE, so it looks like this:
DECLARE
CURSOR c1 IS SELECT dummy FROM dual;
and I highlight the same SELECT through ; or SELECT through dual and
press F9, I get en Edit SQL window that reads:
/* Formatted on 5/8/2012 1:02:55 PM (QP5 v5.185.11230.41888) */
SELECT dummy FROM DUAL;
I'm on TOAD 11.0.0.116 as I haven't had a chance to get the latest
loaded up yet. I often highlight and run the SQL in a cursor before
execution to see the result set as a last sanity check before
execution. I've done this many, many times, but lately I get the Edit
SQL window instead of execution and a result set. Any idea why? Have I
changed some setting in the options by accident or something?
John
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/