Parameter Queries in Oracle?

Hi y'all,

I am making queries and views on an Oracle database from MS Access. I now try to make something like, what is called in Access terms, a parameter query. It looks like this:

Select *
From Places
Where PlaceType = [parPlaceType]

I want to be able to set this parameter from Access. I also want to ignore this parameter if it is not filled.

Does anyone know how to do (something like) this?

I'd really appreciate some help!

TIA, Edgar Walther Received on Thu Aug 26 1999 - 15:28:54 CDT