| SQL Parsing Tool [message #203611] |
Wed, 15 November 2006 16:25  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Question from a colleague that I couldn't answer, and couldn't find on a search:
Does anyone know of a tool that can parse SQL statements and return results of the parse beyond mere success or failure (a-la Explain Plan). For, example, it could give a list of tables, columns, hints, join columns, whatever. I appreciate that some of this detail can be retrieved from the PLAN_TABLE, but he's looking for more.
Quest's SQL Impact has been suggested, but it is not fully compliant with 9i/10g, and is apparenetly no longer supported by Quest.
Ross Leishman
|
|
|
|
| Re: SQL Parsing Tool [message #203683 is a reply to message #203611] |
Thu, 16 November 2006 00:46  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
The claims made here (alternative site) sound promising, albeit it is a general (not Oracle-specific) parser, so hints might be left out.
| Quote: | It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete or create and so on), what's table and fields are used in a statement, and different parts of a SQL statement are also available such as where clause, group by clause and having clause and so on.
|
Hmm, when writing this and searching further, it turns out this one is referenced by in many hits, so you probably ran into it already..
|
|
|
|
| Re: SQL Parsing Tool [message #203901 is a reply to message #203683] |
Thu, 16 November 2006 21:28 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Thanks, but really looking for something that will handle all of those little Oracle-isms (MERGE, INSERT ALL, CONNECT BY, blah, blah) gracefully.
I'll pass on the link though.
|
|
|
|
| Re: SQL Parsing Tool [message #204028 is a reply to message #203611] |
Fri, 17 November 2006 06:35 |
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
|
Senior Member |
|
|
"Quest's SQL Impact has been suggested, but it is not fully compliant with 9i/10g, and is apparenetly no longer supported by Quest."
Surely Quest most have another tool for this purpose, like a plug-in modul in Toad, dont know if it's that gracefull thou 
[Updated on: Fri, 17 November 2006 06:36] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
