3 Replies Latest reply on Mar 12, 2014 2:06 AM by sb92075

    Formatting long numbers  using sqldev

      Hi All,

       

      11.2.0.1

       

      How do I format output report selected in sqldev  on csv or xcel report?

       

      Everytime I selected I long number column or char column like ACCT_NO  it will turn as scientific in csv or xcel e.g.

      2.71433E+11

       

      My work around is to select ''''||ACCT_NO from EMP.

      Is there a better solution?

       

       

      Thanks all,

      pK