Re: Parameter Query in Oracle?
From: Alexander Romanov <sashar_at_comita.spb.ru>
Date: 1999/08/26
Message-ID: <7q2uhh$e5i$1_at_dragon.infopro.spb.su>#1/1
Date: 1999/08/26
Message-ID: <7q2uhh$e5i$1_at_dragon.infopro.spb.su>#1/1
Hello
You can create predetermined View with parameters
or
create stored procedure with use Dynamics SQL
First - more reliably also is faster executing
Two - is more floppy - you can set required parameters dynamically
Use ODBC for create big complex question - is bad idea - it results in
strong decline
of productivity.At any opportunity it is necessary to transfer difficult
actions on a server side.
Best regards
÷ÓÅÈ âÌÁÇ
--- Origin ... ðÒÏÓÔÏ ÎÁÄÏ ÏÞÅÎØ ×ÅÒÉÔØ ÜÔÉÍ ÓÉÎÉÍ ÍÁÑËÁÍ... Romanov Alexander Certified Oracle DBA on www.tekmetrics.com/transcript.shtml?pid=13518 Alex_Romanov_at_mail.ru ICQ 6220754 Edgar Walther ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <7q0ubo$jd3_at_newstoo.ericsson.se> ...Received on Thu Aug 26 1999 - 00:00:00 CEST
>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?