Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL analyze tool
apogeusistemas_at_gmail.com wrote:
> Do you know any tool to analyze SQL commands to verify if is there any
> error
> and suggest a change ?
>
If you mean syntactic verification, you might like to check http://www.orafaq.com/cgi-bin/sqlformat/pp/utilities/sqlformatter.tpl . As name implies, it actually formats sql (or pl/sql) statements. But, it knows about syntax, so it refuses to format statements that have syntax errors.
-- Arto Viitanen, CSC Ltd Espoo, FinlandReceived on Mon Dec 18 2006 - 00:52:04 CST
![]() |
![]() |