Date: Tue, 17 Mar 1998 18:31:12 -0500
Reply-To: Thomas Huang <NYPRO.THuang@SDPS.ORG>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Thomas Huang <NYPRO.THuang@SDPS.ORG>
Subject: parameter query in ORACLE
This is not exactly a SAS question, but it's about something I can do in
SAS and I'd like to know if I can do the same in MS ACCESS.
The question is: Is there such a thing as parameter query in ORACLE? I
created a pass-through query to access data in ORACLE from MS
ACCESS and it worked fine. But I want the query to prompt the user to
enter the criteria (I guess this is called parameter query in MS ACCESS)
for a certain field before the query get submitted to ORACLE.
I know this can be done in SAS by creating a macro variable. For
connect to oracle (user='xxx' orapw='yyy' path='@zzz');
create table CLAIMS as
select * from connection to oracle
Thanks in advance!