Thursday, September 8, 2011

to_char, nls_numeric_characters

Сегодня натолкнулась на новенькое для меня.
return to_char(i_amount, '9G999G999G999G990D99', 'nls_numeric_characters = ''. ''');

Поисковые слова погуглить - oracle to_char NLS_NUMERIC_CHARACTERS
Posted by at
Labels: ,

2 comments:

  1. OlenkaSeptember 8, 2011 at 1:25 AM

    http://oracleeducation.blogspot.com/2008/02/nlsnumericcharacters-decimal-character.html

    ReplyDelete
  2. OlenkaSeptember 8, 2011 at 1:32 AM

    Table 2-14 Number Format Elements!
    http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/sql_elements004.htm#CHDHJBHA

    ReplyDelete

Subscribe to: Post Comments (Atom)