Re: Syntax checker for Oracle?

Stefan Humphreys wrote:
>
> I am dynamically building an update statement that will be later submitted
> as a batch job. I would like to know that the statement is syntacically
> correct before I save it.
>
> Is there a way to check the syntax of a SQL statement in Oracle without
> actually running the query?
>
> Thanks in advance,
>
> Stefan

You can't do this for UPDATE statements, but for SELECTs you could just take the explain plan...

TT Received on Thu Jan 09 1997 - 00:00:00 CST