none
How do i get Oracle Query data in MS Server Table..? RRS feed

  • Question

  • I am accessing Oracle server database and it is mirror database. So i have only read only access to this database.

    For my application, i am using MS SQL Server database. I want to fetch data from Oracle database for internal processing.

    How do i get all the Oracle Query data into my SQL server table without creating linked server.?

    Is it possible to create Oracle Mirror dB data to my MS SQL Server table.?

    My oracle query like below : 

    select DISTINCT 
    name,nvl(NUMBER,' ') AS NUMBER,
    nvl(STATE,' ') AS STATE,nvl(FROM,' ') AS FROM,nvl(TO,' ') AS TN_TO,
    from table1
        /* more joins here    */
    UNION
    select DISTINCT 
    name,nvl(NUMBER,' ') AS NUMBER,
    nvl(STATE,' ') AS STATE,nvl(FROM,' ') AS FROM,nvl(TO,' ') AS TN_TO,
    from table2
        /* more joins here    */
    UNION
    select DISTINCT 
    name,nvl(NUMBER,' ') AS NUMBER,
    nvl(STATE,' ') AS STATE,nvl(FROM,' ') AS FROM,nvl(TO,' ') AS TN_TO,
    from table3
        /* more joins here    */
    UNION
    select DISTINCT 
    name,nvl(NUMBER,' ') AS NUMBER,
    nvl(STATE,' ') AS STATE,nvl(FROM,' ') AS FROM,nvl(TO,' ') AS TN_TO,
    from table4

    So the same result i want to get it to my MS SQL Server table.

    How do i do this....?

    Monday, August 26, 2019 1:32 AM

Answers

All replies