4 Replies Latest reply on Apr 26, 2013 9:22 AM by Rocco Pinneri

    how can i get data from 2 oracle instances in to single worksheet

    suneelkumar kesana

      Hi Team,

       

      My requirment is to get the data from two different oracle instance in to singel table worksheet.

       

      ex:

      orace instance1

      table1

      site (1,2)

      column slaes(20,30)

      column created date (1/1/200)

       

      orace instance2

      table2

      location (3,4)

      column slaes (40,50)

      column created data (1/1/2001)

       

      Now i want to see all the data from both orcle instances into single worksheet as below

       

      Sitesalescreated date
      1201/1/2000
      2301/1/2000
      3401/1/2001
      4501/1/2001

       

      please let me know how we can achive this. and also let me knoow if it is not possible.

       

      Thanks,

      Skumar