Re: Parameter Query in Oracle?
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: 1999/08/26
Message-ID: <PF9x3.4983$9K.7029_at_news.rdc1.nj.home.com>#1/1
Date: 1999/08/26
Message-ID: <PF9x3.4983$9K.7029_at_news.rdc1.nj.home.com>#1/1
then that should take care of you.
This assumes that you can handle a bind variable in Access.
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 P.S. If you would like to talk to Dulcian about a salaried position on our team, please call me. We have openings in NJ for developers, in CA for PERL developers. Edgar Walther wrote in message <7q0ubo$jd3_at_newstoo.ericsson.se>...Received on Thu Aug 26 1999 - 00:00:00 CEST
>Hi y'all,
>
>I use MS Access to generate reports from an Oracle 7.3 database.
>For performance reasons I want to make a parameter query in Oracle.
>
>It should do something like this:
>
>SELECT *
>FROM Places
>WHERE Place_Type = <parPlaceType>
>
>I also want to be able to have the query ignore the parameter if it is not
>filled in (adding like * to it is not what I need).
>
>How can I do this? Should I make a view with parameters? Should I do
>something with stored procedures? Dynamically build the SQL string for an
>SQL PassThrough query?
>
>Can anyone help me with this?
>
>TIA,
>
>Edgar
>
>
>
>
>