Extracting data from multiple tables in Oracle 9i
I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS.
I AM USING ORACLE9I .
Software/Hardware used:
Software/Hardware used:
ASKED:
May 19, 2009 6:56 AM
UPDATED:
May 19, 2009 10:57 PM
Answer Wiki:
More information about the table relationships and the reason for redudant data would be helpful.
Is the redundant data in columns of differnt tables or do you have duplicate rows?
Does the data need to be stored into another table or could you create a view?
If the tables have a one to one releationship, you could create a view that joins each table and returns just the columns from each table that you want.
--------------------------------------------------------------------------------------------------------------------------------
Randym is right. Perhaps a good way to figure out how the rows match up is to create samples in Excel and have the data approved by your customer. Then you can write the SQL based on how the data lines up in Excel.
To see all answers submitted to the Answer Wiki: View Answer History.
Moderator Note: Hello Umm and welcome to IT Knowledge Exchange. On future questions, please do not use all caps. This makes it difficult to read your question. I’ve edited the question title to normal case. Thanks for your cooperation and good luck with your Oracle issue.
You would get more useful answers if you were more specific in your question.
If you have to store data from 18 different tables into one single table, then you must have a way to establish relations between tables.
Provide more details, and I’m sure you will get good answers.