1 Reply Latest reply on Sep 1, 2014 2:45 PM by rp0428

    SQL Developer export data from grid

    Heinz

      HI ! I'm trying to export data from a grid into a file with insert statements.

      The problem is the format mask for timestamp columns.

      "to_timestamp('22.11.2013 07:08:27,000000000','DD.MM.YYYY HH24:MI:SSXFF')"

      and this can't be inserted. I will get an ORA-01830, because of the comma after the second.

      Any idea ?

       

      Thanks, Heinz

        • 1. Re: SQL Developer export data from grid
          HI ! I'm trying to export data from a grid into a file with insert statements.

          The problem is the format mask for timestamp columns.

          "to_timestamp('22.11.2013 07:08:27,000000000','DD.MM.YYYY HH24:MI:SSXFF')"

          and this can't be inserted. I will get an ORA-01830, because of the comma after the second.

          What is your full version of sql developer?

           

          Did you set the 'Timestamp Format' in the NLS preferences? If so, what did you set it to?

           

          Check the format settings at Tools -> Preferences -> Database -> NLS and set the three date/time related formats there to the values you want.