4 Replies Latest reply on Sep 1, 2016 5:13 PM by user4279990

    Sql Developer 4.0.2.15 + 4.1.3.20 - Issue with export wizard and insert queries

    user4279990

      Hello,

       

      I use to generate insert statements with the export wizard in Sql Developer.

      Suddenly the insert statements treats every table column as if it were a string,

       

      Ex. based on the query "select Idnum, Descr, Weight from Table" (Idnum and Weight being numbers, Desc a varchar(2), ), the generated insert statement,

      instead of :

      insert into Table (Idnum, Descr) values (1, 'Description', 0.0123);

      returns :

      insert into Table (Idnum, Descr) values ('1', 'Description', '0,0123');

       

      I can't find the source of this change ; tried the sql Developer parameters, system regional settings, nls_session with no success.

       

      Does someone have an idea of what could have caused this change ?