Re: Developer question

From: Phil Jones <phil_at_phillip.im>
Date: Mon, 5 Dec 2011 18:10:19 +0000
Message-Id: <C294E07D-A1C6-4C04-9A4A-9166471BDE8E_at_phillip.im>

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

Received on Mon Dec 05 2011 - 12:10:19 CST