Re: Developer question
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: phil@xxxxxxxxxx
- Date: Mon, 5 Dec 2011 12:44:28 -0800
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@xxxxxxxxxx> 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@xxxxxxxxx>
> 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@xxxxxxxxxxxxxxx> wrote:
> >
> >
> >
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
