Re: SQL analyze tool

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 17 Dec 2006 13:00:07 -0800
Message-ID: <1166389204.132292@bubbleator.drizzle.com>

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 ?
>
> I use:
>
> Oracle RDBMS: 9.2.0.7.0
> Oracle Applications: 11.5.5
>
> Regards.

Syntactic ... use SQL*Plus.

Logical ... get 10g and use the DBMS_WARNING built-in.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Dec 17 2006 - 15:00:07 CST