Re: Parameter Query in Oracle?

If you've linked the table throught ODBC, create a query, select the fields you want/need for your report. In the field you want the parameter on, place in the criteria: Like [Enter something] & "*"

should work

hth

In article <7q0ubo$jd3_at_newstoo.ericsson.se>,   "Edgar Walther" <edgar.walther_at_dsn.ericsson.se> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 25 1999 - 00:00:00 CEST