Re: Parsing SQL-statement before executing?

From: Reid Lai <reidlai_at_pacific.net.hk>
Date: Wed, 21 Jul 1999 21:37:42 +0800
Message-ID: <3795CD26.F685A11F@pacific.net.hk>

Oralce must parse the sql first before execution. How can you do that? Please let me know.

Magnus Rosenquist wrote:

> Hi !
>
> Anybody out there who knows if it's possible
> to parse a sql-statement before you execute it?
>
> I'm allowing the users to write their own statements from
> a client, the statement will then be executed in batch so
> any eventual errors will not be displayed until the batch is
> executed.
>
> Is there a way of parsing the statement by using some
> Oracle function and display the outcome to the user?
>
> Thankful for replies.
>
> regards,
> Magnus Rosenquist

--
Best Regards,

Reid Lai
Oracle 7.3 Certified DBA (OCP)

e-mail : mailto://reidlai@pacific.net.hk homepage : http://www.pacific.net.hk/~reidlai

The above opinions are mine and do not
represent any official standpoints of my
employer or third parties.

Received on Wed Jul 21 1999 - 08:37:42 CDT