Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> nls_numeric_character checking function

nls_numeric_character checking function

From: FC <flavio_at_tin.it>
Date: 11 Aug 2004 09:28:09 -0700
Message-ID: <2bd78ddf.0408110828.588447e5@posting.google.com> 





I don't know if it is a FAQ,I couldn't find anything with google,
anyway here is a simple query returning the session values
corresponding to the NLS_NUMERIC_CHARACTER parameter.



select translate(trim(to_char(1,'L9')),' 1',' ') L,

translate(trim(to_char(11,'9G9')),' 1',' ') G,
translate(trim(to_char(1.1,'9D9')),' 1',' ') D,
translate(trim(to_char(1,'C9')),' 1',' ') C from dual;





Bye,


Flavio
Received on Wed Aug 11 2004 - 11:28:09 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US