Extracting data from multiple tables in Oracle 9i

15 pts.
Tags:
Oracle 9i
Oracle administration
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 .

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BrentSheets
    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.
    6,925 pointsBadges:
    report
  • carlosdl
    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.
    69,950 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following