Try to learn what version of Crystal you might be using. One line posts invariably cause others to guess and wastes everyone's time (just like calling technical support, the answer is often different across different versions of the software).
In CR 9 and above, there is a Command Object, and you can paste in real SQL, prior to that one could paste in SQL using an ADO connection, however parameters weren't passed to the database in those types of coneections.
If CR 9 or above, under the connectivity for Oracle, you'll see Add Command, just paste in the SQL that will work as the datasource, and you can generate parmaeters for the SQL at the same time.
-k