SQL & PL/SQL

Hi,

I have a table a which has a this kind of relation
the fields involved
1. region
2. version
3. source
4. project id

Now in the table i have situation like this when for all records that do not have version is equal to something then i have to read all those distinct project ids(which would be names). Now i want to use the result like for certain version numbers there is so many project ids, the result i want to use it for creating a dashboard.

I want help in figuring out, can there be a array variable in pl/sql which can take variable number of arguments

so that we can read version - v1 project_ids('abc','bcd','def');

for each version there can variable number of project ids.

Thank you,
rakesh

Edited by: rakesh119 on Apr 22, 2013 2:21 PM