Re: verify SQL syntax without running it?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 28 Jul 2003 03:58:51 -0700
Message-ID: <1efdad5b.0307280258.7e32b09@posting.google.com>

"Wayne" <invalid_at_invalid.invalid> wrote in message news:<jVFUa.23582$vx3.6287618_at_kent.svc.tds.net>...
> 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.

i know when you use toad you can do this. I believe they use the 'explain plan for ' < query> command then do a query from the plan_table

I never tried it to check syntax. Not 100% sure what they are using. Received on Mon Jul 28 2003 - 05:58:51 CDT