Analytics Software

Hi,
I am new to Discoverer and have tried searching for some documentation to help me with my problem, but so far I have found nothing useful. Let me explain what I want:

1. Create a SQL query and Export it to Excel. (I can manage this).
2. Put a parameter in the SQL from (1) and loop through a table and for each row in the table create a new Excel file, automatically.


--SQL (2)
FOR users IN (SELECT User_id
FROM all_users) LOOP
-- SQL (1)
SELECT * FROM all_objects where owner = users.user_id;
END LOOP;

Somehow I want to loop or join and save each User_ID data in an Excel file.

The reason for not doing a JOIN is that I wan the results in different Excel file and also becuase of the complications of the query I am trying to implement, if I use more than one value for my selection (i.e user_id) there is not enough memory.

Any help will be appreciated.

Thanks.