Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL analyze tool

Re: SQL analyze tool

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Mon, 18 Dec 2006 08:52:04 +0200
Message-ID: <45863a91$0$8950$ba624cd0@newsread.funet.fi>


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, Finland
Received on Mon Dec 18 2006 - 00:52:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US