1 Reply Latest reply on Sep 9, 2020 4:17 PM by Glen Conway

    Export to .xls (sqlxlsx) missing dot

    3235439
      About

      Oracle SQL Developer 20.2.0.175

      Version 20.2.0.175

      Build 175.1842

      IDE Version: 12.2.1.5.42.200515.1304

      Product ID: oracle.sqldeveloper

      Product Version: 20.2.0.175.1842

      step 1

      1.png

      step 2

      2.png

      step 3

      Screenshot_1.png

      Missing "." betwen sql and xlsx

      Upd post.

       

      Сообщение отредактировано: 3235439

        • 1. Re: Export to .xls (sqlxlsx) missing dot
          Glen Conway

          One might argue that SQL Developer should display an error message and not create any file in this case.  What is happening here?  Windows does not want you to clutter up the C:\ root directory with regular files.

           

          Of course, you can create a directory in C:\, or even create a regular file there if you are running as Administrator.  For the non-Administrator case, we get...

          Capture.JPG

          So best practice is to avoid writing to C:\ and instead create your own output directory somewhere and write to that.

           

          Edit: Actually, in most situations, SQL Developer will display

          CaptureExport.JPG

          but you seem to have found an edge case.  In playing around a bit, I also saw the same behavior one time, but then could not get it to repeat.