Toad World® Forums

"Show SQL" button is greyed out

In “Compare data” the “Show SQL” button is greyed out in all the “Data Comparsion” tabs except for “row counts”. How can I see the SQL that will be used?

If you are using the “Row by Row” option, the tables are not compared by a query. Toad is querying each table separately and comparing the results. Those buttons are enable when you use the “minus” method, because in that case the data is being compared between the two tables by a query that includes them both.

The minus option is what I am referring to. I am on 12.1.0.22. I have attached screen shots
toad issue.docx (159 KB)

Thanks. That looks like a bug.

From: dbiddle [mailto:bounce-dbiddle@toadworld.com]

Sent: Friday, March 07, 2014 12:56 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] "Show SQL" button is greyed out

RE: "Show SQL" button is greyed out

Reply by dbiddle

The minus option is what I am referring to. I am on 12.1.0.22. I have attached screen shots

Attachments:

toad issue.docx

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.