6 Replies Latest reply on Mar 17, 2016 2:25 PM by 3198487

    SQL Developer - Query Using multiple Connections

    3198487
    3198487 Mar 15, 2016 4:39 PM

      Hi,

       

      I've two connections: the first one is an Oracle Datable Connection and the another one is a MDB (Access) connection.
      The idea is use the MS Access connection to get the parameters, like a front end settings, then i start my query to get data from Oracle. At the end the query will populate the MS Access database.

       

      The problem is that the SQL Developer doesn't allow to use one query accross two or more connections at the same time.

      And beyond that i've only read access on Oracle Database, so i can't migrate my data there.


      My SQL Developer version is 1.5.5

       

      Query Example:

      "SELECT * FROM [ORACLE DATABASE]
      WHERE DATE < (SELECT DATE FROM [MS ACCESS DATABASE])"

       

       

      Thx for your pacience and help!


      ----------------------
      Greetings from Brazil
      "Fora Dilma!"