Can you send me the query so that I can tell you which condition you are missing that is making your query a cartesian product? Do you need to use all 30 tables? Can you tell me what the format is for the flat file and how they relate to the columns from the 30 tables? It is very difficult to answer the question without more specifics.
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.