5 Replies Latest reply on Mar 5, 2013 2:03 PM by riedelme

    Is DataType conversion required while inserting data from sql server to orc

      Hi All,

      Is it data coversion required while inserting into Oracle data base(table) using sql server (linked server) in oracle database;

      for example : insert into oracle tabel name (col,col2)
      select cast(col1 as varchar2),cast(col2 as bumber) from linkedserver.dbo.sqlservertable;

      do we need to insert in the above method or what ?