DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Numeric format

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Numeric format

    Hi,

    For the below query, result is displayed in exponential format,What i've to do
    to get this query result in integer format?

    SQL> select dbms_flashback.get_system_change_number from dual;

    GET_SYSTEM_CHANGE_NUMBER
    ------------------------
    2.7762E+12

    Thanks...

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    wow, a smple sqlplus setting - numwidth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width