Hi All,
I am using toad version 13.2 but when I run the query if data contains xml I am getting an table view or does not exit.
The same query its working in lower version.
could you please let me know if any has any work around 13.2 verion?
13.2 had a problem displaying XML so we had to do some clever tricks behind the scenes to make it work. The problem was, they weren't clever enough for complicated SQL.
One workaround you can do is make a view for your complicated SQL, then select from your view instead of your complicated SQL.
Or, better yet, update to the latest version if you can. In the latest version, we don't have to use our "clever" trick so it will just work.