SQL & PL/SQL

Hi all,

I have a procedure and I'm using a ref cursor for fetching data. Prior to fetching I have many cursors from many temporary tables and I don't want to use much temporary table for SP. So without using any table how I can make ref cursor .
Basically you need a select statement to make a ref cursor and that select must be from a table, that may be temporary table but without select from any table can I use plsql collection(varray,nested table,table type) object converting it into table using "table function"

if possible then give me some reference.

Thanks in Advance.

Sajal.