Thank you for your suggestions I will try it out.

Thanks for your reply,

Reason why we are using temporary tables in oracle is that we have a query engine that besides doing sql queries on a relational database it also...