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

    SQL Developer export data from grid

    Heinz
    Heinz Sep 1, 2014 12:21 PM

      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

      • 572 Views
      • Tags:
        • 1. Re: SQL Developer export data from grid
          rp0428 Sep 1, 2014 2:45 PM (in response to 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.

          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.