Re: Validating SQL ??

Can you syntax check SQL before actually running it? In SQL*Plus you can explain the SQL. This will produce a plan when valid or syntax error messages when an error exists.

In Pro*C you set the compile option sqlcheck=full and provide a userid and password to log into the database with.

Matthew Green <matthewgreen_at_powersoft-services.co.uk> wrote in article <3692017F.2D44C35E_at_powersoft-services.co.uk>...
>
> Is there a command which will let me validate SQL statements before
> applying them e.g..
>
>
> update contacts
> set name = 'ABC'
>
>
> so I want to check if the syntax is right before executing.
>
>
> If you can shed any light
>
>
> Thanks
>
> Matt
>
>
>
>
>
Received on Tue Jan 05 1999 - 08:29:12 CST