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