12 Replies Latest reply on Sep 27, 2017 4:28 PM by rp0428

    export/save output in xls format

    goodluck247

      Hello all,

       

      In SQL DEV, when we run a QUERY, we get a QUERY RESULT, and we can right-click on the data, and get an EXPORT option, like this:

       

      query_result.JPG

       

      And we can export the data in a number of different formats.

       

      However, if I run a procedure with dbms_output..., I get SCRIPT OUTPUT, and there are no options if right-click on the data, like this:

       

      script_output.JPG

       

      Is there any way to export the data directly from the script output in, say, xls format?

      And why is there not an EXPORT option available, just like in QUERY mode?

       

      Thank you.