Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Checking SQL syntax

Re: Checking SQL syntax

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 09 Apr 2003 21:55:52 +0200
Message-ID: <3E947AC8.3040703@netscape.net>


ES wrote:
> Hello,
>
> our application build an sql query with an intermedia clause :
> the user write the word list he is seeking and we build the where clause.
>
> we need to allow the user to use the complete intermedia syntax, including
> near, fuzzy, ...
> but when an error is writen by the user, we have a really bad reaction from
> oracle 8i (core dump, instance falling down)
>
> does it exist a package that will test and agree a sql phrase without
> executing it ?
>
> thanks
>
>

select 1 from dual where 1 = 2 and ...(your where clause)

-- 
Regards, Frank van Bortel
Received on Wed Apr 09 2003 - 14:55:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US