1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

insert into oracle_table (column1) select column1 from ms_sql_table

Discussion in 'SQL PL/SQL' started by ecivgamer, Aug 19, 2014.

  1. ecivgamer

    ecivgamer Active Member

    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    130
    Hi all,

    how do I import data from ms sql table ?

    begin
    insert into oracle_table (column1)
    select column1 from ms_sql_table;
    commit;
    end;
     
  2. ecivgamer

    ecivgamer Active Member

    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    130
    Upd:

    I think about creating a heterogeneous data source, so I can query a MS SQL Server database from within Oracle. Is it possible at all?
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation