Re: Developer question

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Mon, 5 Dec 2011 12:44:28 -0800
Message-ID: <CACpWLjNPuCECSgyftarfn+XfdeecT-4vLfDjkX6p3fWPp1kw7A_at_mail.gmail.com>

You want to check validity, but validity consists of two parts. 1) Is the syntax valid
2) Are the semantics valid
But Tom says it better than I ever could.

http://www.oracle.com/technetwork/issue-archive/o42asktom-083098.html

On Mon, Dec 5, 2011 at 10:10 AM, Phil Jones <phil_at_phillip.im> wrote:

> You can EXPLAIN PLAN a fair amount of things to check syntax. That parses
> without executing.
>
> Cheers,
>
> Phil
>
> On 5 Dec 2011, at 17:58, Subodh Deshpande <deshpande.subodh_at_gmail.com>
> wrote:
>
> > Yes Chiris,
> > so you mean to say that is there any utility that will inform whether
> there
> > is any error in the syntax while writing sql query and also such utility
> > should inform about the correctness of the objects used..etc..
> >
> > I think there is no such tool..that can do it for you..I also felt
> > necessary of such tool when I used to work as developer and application
> > maintenance support team member..
> >
> > but suppose you want to prepare script to say rebuilt indexes, count (*)
> > from tables..or compiling objects etc..
> > then you can prepare such scripts using sql*plus or toad kind of tool..
> >
> > thanks and take care...subodh
> >
> > On 5 December 2011 21:06, Taylor, Chris David <
> > ChrisDavid.Taylor_at_ingrambarge.com> wrote:
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 05 2011 - 14:44:28 CST