Re: Syntax checker for Oracle?
From: Troy N. Terry <troyt_at_eventus.com>
Date: 1997/01/09
Message-ID: <32D59102.409A_at_eventus.com>#1/1
Date: 1997/01/09
Message-ID: <32D59102.409A_at_eventus.com>#1/1
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 CET