Toad World® Forums

Spool SQL

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. :slight_smile:

Blessings,

Phyllis


Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

Hi!

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!

Dave Venus

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Monday, June 13, 2016 4:08 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Spool SQL

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. :slight_smile:

Blessings,

Phyllis

Phyllis Helton

Data Magician

Digital Products & Strategies, Cru | Data Sciences & Analytics

Office :phone: 407-515-4452

phyllis.helton@cru.org

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
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.

It would be even better if you use proper communication channel for that:

www.toadworld.com/…/i

Sorry! Forgot that is the way to do this now. Which is sad considering how long the Idea Pond has been around.

I have submitted this properly this time. :slight_smile:

On Tue, Jun 14, 2016 at 3:31 AM, Damir Vadas bounce-damirvadas_250@toadworld.com wrote:

RE: Spool SQL

Reply by Damir Vadas
It would be even better if you use proper communication channel for that:

www.toadworld.com/…/i

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

I like this idea. Next beta will have:

  1. Session and timestamp info as a comment

  2. A button to copy all/selected/last sql statement to the editor

  3. A checkbox to substitute binds back into the SQL statement. Substitution variables are already substituted by this point, so I can’t make an option to not substitute them.

Thanks John! I know I’ll use this. :slight_smile:

On Tue, Jun 21, 2016 at 4:48 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Spool SQL

Reply by John Dorlon
I like this idea. Next beta will have:

  1. Session and timestamp info as a comment
  1. A button to copy all/selected/last sql statement to the editor
  1. A checkbox to substitute binds back into the SQL statement. Substitution variables are already substituted by this point, so I can’t make an option to not substitute them.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org