1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Number formatting

Discussion in 'SQL PL/SQL' started by neelambhumij, Nov 18, 2015.

  1. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi All

    I have an issue with a sql query. Any help will be really appreciated.

    The test and Prod environments are producing the column name differently.Is there any setup difference.
    I can only think of NLS_NUMERIC_CHARACTERS that is looking the same for both.

    upload_2015-11-18_15-10-0.png

    Prod is returning column name as NVL(1, 0)
    while test returning NVL(1, 0.0)

    Thanks and Regards
     
  2. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Better use alias.,

    Code (SQL):

    SELECT nvl(1,0.0) AS col1 FROM dual;

    COL1                  
    -------
    1  
     
    And by the way, I'm not facing the issue.,