Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    34

    Unanswered: how to stick a number format to a session

    Hi All

    How to stick a number format to a session. Our client wants all
    numeric amounts returned by functions as resultsets in a particular
    format (9,99,999.00) .Front end is Java. How do i force a numeric
    format to a session when some java user connects via JDBC.

    something on the lines we set nls_data_format on user logon.


    Regards
    Sushant

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    15
    Hi Zulu
    Use to_char and to_number functions in select statement

    e.g.
    select to_number(to_char(12345.678,'999,999,99.99'),'999, 999,99.99') from dual;

Posting Permissions

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