The NLS_DATE_LANGUAGE parameter explicitly changes the language for abbreviations and names of days and months, and for spelled-out values of other date format elements.
NLS_DATE_LANGUAGE = language
Example :
select to_char(to_date('01-' 'JAN' '/' '2005','dd-MONTH/yyyy',
'NLS_DATE_LANGUAGE = ''ENGLISH'' ') ,
'MONTH DD, YYYY')
from dual
More Oracle
Mas Oracle
Etiquetas: Parameters, PL/SQL
The NLS_NUMERIC_CHARACTERS parameter explicitly specifies a new decimal character and group separator.
The text value must have this form: 'dg'
- d is the new decimal character.
- g is the new group separator.
The decimal character and the group separator must be two different single-byte characters, and cannot be a numeric value or any of the following characters: plus sign ("+"), less-than sign ("<"), minus sign or hyphen ("-" ), or greater-than sign (">").
If the decimal character is not a period (.), you must use single quotation marks to enclose all number values that appear in expressions in your SQL statements.
When not using a period for the decimal point, use the TO_NUMBER function to ensure that a valid number is retrieved.
EXAMPLE 1 :
to_number( products.price, '999G999G999D999999', 'NLS_NUMERIC_CHARACTERS = ''.,''')
EXAMPLE 2 :
to_number(products.price, '999G999G999D999999', 'NLS_NUMERIC_CHARACTERS = ''.,''')
EXAMPLE 3 :
SELECT to_number('10.123456', '999G999G999D999999',
'NLS_NUMERIC_CHARACTERS = ''.,''') FROM DUAL
More Oracle
Mas Oracle
Etiquetas: Parameters, PL/SQL
