Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Location
    Scotland
    Posts
    17

    Angry Unanswered: Working With 2 tables

    Hi,

    We have an Oracle table (Table A) which hold's one set of information. There is another table on another server with another set of data which is not an Oracle table (Table B).
    The address information in one must match the other, If a user enters an address then the query will look at Table A, it is hoped that the query will then look at Table B and extract information based on the result of two matching addresses.
    Is this possible? Does anybody have any advice on this?

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You could use the Oracle Gateway products,if one is available for your other database, and then you could just query the other system using sql.

    Alternatively you could get the other system to replicate its data over to your Oracle database and then you would have two address tables which you could just join.

    If neither approach is possible you would probably need to write some sort of app to sit in the middle which gets the data from both Oracle and your other system and then decides what to do.

    Alan

  3. #3
    Join Date
    May 2003
    Posts
    87
    And if you have Oracle 9i, you can use external tables too.

  4. #4
    Join Date
    Jun 2003
    Posts
    3

    DB-Link

    Hi!

    You can add a db-link to the other database and also have a look up there.

    The db-link is quite easly to make and you will then access the database in an ordinary sql query.

    PP

  5. #5
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204

    Re: Working With 2 tables

    Originally posted by sypher
    Hi,

    We have an Oracle table (Table A) which hold's one set of information. There is another table on another server with another set of data which is not an Oracle table (Table B).
    The address information in one must match the other, If a user enters an address then the query will look at Table A, it is hoped that the query will then look at Table B and extract information based on the result of two matching addresses.
    Is this possible? Does anybody have any advice on this?
    If Table B is not an Oracle table, exactly what is it? As has been mentioned, the solution depends on your answer. Also, please provide which Oracle version and what OS is involved.

    HTH,
    Patrick

  6. #6
    Join Date
    Jan 2003
    Location
    Scotland
    Posts
    17

    DB and OS

    Hi,


    The database table B is in access97, table A is Oracle 9i. The operating system we're working on is Windows 2000. Hope this helps.

    Thanks everybody for your help
    Last edited by sypher; 06-26-03 at 06:29.

  7. #7
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204

    Re: DB and OS

    Originally posted by sypher
    Hi,


    The database table B is in access97, table A is Oracle 9i. The operating system we're working on is Windows 2000. Hope this helps.

    Thanks everybody for your help
    Ok, that's a start. Now, what tool are you using for the query? Are you writing custom code in a specific programming language, using a query tool like SQL*Plus on the Oracle side, running the query in Access, or something else?

    Again, the more information you give, the easier it will be to supply the answer.

    HTH,
    Patrick

  8. #8
    Join Date
    Jan 2003
    Location
    Scotland
    Posts
    17
    Thanks again for your help

    I plan to do it on SQL plus on Oracle 9.

    Thanks

    Sypher

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •