If someone provides you a really complicated query is there a way to use the toad query builder to help you? I would like to make one small change to the query. I would like to select a couple of columns from another table and join it somehow. If I understood what I was looking at this would be simple to do.
Fortunately, there is a process within Toad for Oracle that might allow you to do this.
If the other user has sent you the text of the SQL, you can bring up the Visual Query Builder palette within Toad for Oracle, and paste the query code into the Generated Query subtab, per screen shot below. As soon as you do that, you’ll see a message saying that the Diagram and Query Text are not in sync, with instructions on how to sync the diagram with the SQL code. All this is assuming that you have access and permissions to the same database and tables, etc.
Please note that reverse-engineering a query diagram from SQL grammar can be very difficult, and Toad may not be able to create the diagram.
