Very complex query
Hi,
I need to do a report on my app with info from many tables. I have been trying to do it all in one huge query. About 10 joins, 6 subqueries, aggregate functions with totals. The query is really big and don't get it to work right.
Is there any better solution to deal with this? Maybe doing all process on stored procedure? Any new fresh idea, beacause I'm stuck.
TIA,
Pedro
Edited 1 time(s). Last edit at 11/02/2011 11:03AM by Pedro de la Lastra.
Subject
Views
Written By
Posted
Very complex query
1416
November 02, 2011 08:08AM
666
November 03, 2011 08:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.