Re: nls_numeric_character checking function

"FC" <flavio_at_tin.it> a écrit dans le message de news:2bd78ddf.0408110828.588447e5_at_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

For D and G:
select value from v$nls_parameters where parameter='NLS_NUMERIC_CHARACTERS'; select value from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS';

Idem for C with NLS_ISO_CURRENCY.
Idem for L with NLS_CURRENCY

-- 
Regards
Michel Cadot