SQL & PL/SQL

Hi

I need to use an array of numbers such as a VARRAY or Associated Index Array so that I can do the following SQL:

select *
from *
where array is null or id is in array

So that if the array is empty it will return all the records, and if the array is not empty then it will return only the rows associated with the ids in the array.

Is this possible?

Regards,

Néstor Boscán