Re: verify SQL syntax without running it?

From: Svend Jensen <Svend.S.Jensen_at_it.dk>
Date: Sun, 27 Jul 2003 18:40:32 +0200
Message-ID: <3f240073$0$32475$edfadb0f@dread16.news.tele.dk>

Wayne wrote:

> I'm using VB + ADO to access an Oracle back end. I'm writing an end-user
> query tool that builds and executes SQL. Is there a way I can check the SQL
> syntax against the RDBMS without actually returning a resultset?
>
> Thanks.
>
>

Explain plan would be a fitting tool. You get a syntax check and the execution plan in one go. And while you are at it - check if the sql statement performs decent - or if you have to rewrite it or take any other means to get it to perform.

Many nice tools can do this for you, or check the doc's - explain plan - there are some tools included in the rdbms for dealing with this issue.

/Svend Jensen
Remove the spam killer [S.] in the reply address. Received on Sun Jul 27 2003 - 11:40:32 CDT