Parameter Query in Oracle?
From: Edgar Walther <edgar.walther_at_dsn.ericsson.se>
Date: 1999/08/25
Message-ID: <7q0ubo$jd3_at_newstoo.ericsson.se>#1/1
Date: 1999/08/25
Message-ID: <7q0ubo$jd3_at_newstoo.ericsson.se>#1/1
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
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 Received on Wed Aug 25 1999 - 00:00:00 CEST