I would 2nd this request! And add 3 related ideas:
Idea 1 – list all substitution variables (& and &&) as well as bind variables as comment entries
Idea 2 – list connection information (user@database) as comment entry
Idea 3 – the ability to “spool” output to a new (or existing) edit window so that we don’t have to copy and paste from the output window to an edit window. Oracle’s SQLDeveloper has a capability like this.
We do a lot of SQL that generates SQL statements to be executed. These items would make doing that much simpler and quicker.
Thanks for your consideration of all of these suggestions!
From: phyllis.helton_1150 [mailto:firstname.lastname@example.org]
Sent: Monday, June 13, 2016 4:08 PM
Subject: [Toad for Oracle - Beta Discussion Forum] Spool SQL
Thread created by phyllis.helton_1150
It would be so nice if when you spool sql to the screen if the statements were ended with semicolons and the session a, timestamp and bind variable lines were prefixed with two dashes. That way when I spool the SQL and then put it in the editor, I can modify and run the statements I’m looking at without having to do that myself.
I’ve been thinking this for a while and figured it was time to make it a request.
Digital Products & Strategies, Cru | Data Sciences & Analytics
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
this post as spam/abuse.
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.