Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Syntax checker for Oracle?
Troy N. Terry wrote:
>
> 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
Perhaps you can write a ProC program which prepares the statement but does not execute it. The prepare should raise an exception if it cannot parse the statement. Received on Fri Jan 10 1997 - 00:00:00 CST