Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dynamically generated SQL options?
Incidentally the select and from clauses always stay the same.
Jason
"Jason Kratz" <jkratz_at_rctanalytics.debug.com> wrote in message
news:8p5u1i$jt2$1_at_flood.xnet.com...
> We have a VB app here which has a query form for the user to fill out.
> Based on those values it dynamically generates a where clause which it
then
> sends to the database. This seems like something that can't be turned
into
> a stored proc but I'm interested if anyone has any ideas on how to handle
> this in a more efficient way (if any).
>
> Thanks,
>
> Jason
>
>
Received on Wed Sep 06 2000 - 12:27:36 CDT