Re: verify SQL syntax without running it?

Hi Wayne,

you could place the script in a transaction (

begin transaction
..
  users script
..
end transaction

HTH Jens

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.
>
>
Received on Sun Jul 27 2003 - 11:39:11 CDT