Return
-
Title
Unable to find the button to show the SQL Statement during Data Compare in Toad -
Description
Unable to find the button to show the SQL Statement during Data Compare in Toad. The icon is located in the upper right corner of the comparison to show the SQL statement on each tab of the process, Source tab, Target tab and Differences tab.
In 13.1 the option to show SQL statement is no longer available, however it can be enabled manually, see more details in the workaround
-
Resolution
WORKAROUND
1. In Toad for Oracle | View menu | Options | General | Application Data Directory2. Copy this path to the Clipboard3. Close Toad for Oracle4. In my case is : C:\Users\ [ your windows user ] \AppData\Roaming\Quest Software\Toad for Oracle\13.1\User Files5. Paste this path from the Clipboard into the Windows Explorer and6.. Go to User files and edit Toad.ini7. Search for DataCompare8. Add this line: AdvancedMode=19. Save Toad.ini file10. Open Toad for Oracle and try againAfter saving the change and start Toad for Oracle again, it should look like this:
