This discussion is archived
5 Replies Latest reply: Mar 5, 2013 6:03 AM by riedelme RSS

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

983732 Newbie
Currently Being Moderated
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 ?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points