Re: Developer question

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:
> 
> 
> 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: