SQL & PL/SQL

Hi,

I am writing a stored procedure that will get data from different sources and generates a spreadsheet finally. Initial select gets the basic data and following selects merges data.

For this I have created a table in the database, I am populating data into that table using same procedure and finally selecting data from that table to generate spreadsheet.

Now I am planning to use TEMPORARY table instead of creating table in database. Can anyone tell me where I can view samples for temp tables?

Which one is the better option in performance wise?

or

can I handle the whole scenario with cursor? any examples?