Use the following constants to retrieve character information about the current
language. All of the constants are of type PLS_INTEGER
, with each
assigned an integer value.
NAME |
Description |
INTEGER |
VALUE |
day1 |
full name of day 1 | 1 |
sunday |
day2 | full name of day 2 |
2 |
monday |
day3 | full name of day 3 |
3 |
tuesday |
day4 | full name of day 4 |
4 |
wednesday |
day5 | full name of day 5 |
5 |
thursday |
day6 | full name of day 6 |
6 |
friday |
day7 | full name of day 7 |
7 |
saturday |
day1_abbr | abbr. name of day 1 |
8 |
sun |
day2_abbr | abbr. name of day 2 |
9 |
mon |
day3_abbr | abbr. name of day 3 |
10 |
tue |
day4_abbr | abbr. name of day 4 |
11 |
wed |
day5_abbr | abbr. name of day 5 |
12 |
thu |
day6_abbr | abbr. name of day 6 |
13 |
fri |
day7_abbr | abbr. name of day 7 |
14 |
sat |
mon1 | full name of month 1 |
15 |
january |
mon2 | full name of month 2 |
16 |
february |
mon3 | full name of month 3 |
17 |
march |
mon4 | full name of month 4 |
18 |
april |
mon5 | full name of month 5 |
19 |
may |
mon6 | full name of month 6 |
20 |
june |
mon7 | full name of month 7 |
21 |
july |
mon8 | full name of month 8 |
22 |
august |
mon9 | full name of month 9 |
23 |
september |
mon10 | full name of month 10 |
24 |
october |
mon11 | full name of month 11 |
25 |
november |
mon12 | full name of month 12 |
26 |
december |
mon1_abbr | abbr. name of month 1 |
27 |
jan |
mon2_abbr | abbr. name of month 2 |
28 |
feb |
mon3_abbr | abbr. name of month 3 |
29 |
mar |
mon4_abbr | abbr. name of month 4 |
30 |
apr |
mon5_abbr | abbr. name of month 5 |
31 |
may |
mon6_abbr | abbr. name of month 6 |
32 |
jun |
mon7_abbr | abbr. name of month 7 |
33 |
jul |
mon8_abbr | abbr. name of month 8 |
34 |
aug |
mon9_abbr | abbr. name of month 9 |
35 |
sep |
mon10_abbr | abbr. name of month 10 |
36 |
oct |
mon11_abbr | abbr. name of month 11 |
37 |
nov |
mon12_abbr | abbr. name of month 12 |
38 |
dec |
yes_str |
Affirmative response for queries |
39 |
yes |
no_str |
Negative response for queries |
40 |
no |
am_str |
Local equivalent of AM |
41 |
am |
pm_str |
Local equivalent of PM |
42 |
pm |
ad_str |
Local equivalent of AD |
43 |
ad |
bc_str |
Local equivalent of BC |
44 |
bc |
decimal |
Decimal character |
45 |
. |
groupsep |
Group separator |
46 |
, |
int_currency |
Int. currency symbol |
47 |
USD |
local_currency |
Local currency symbol |
48 |
$ |
local_date_fmt |
Local date format |
49 |
%m/%d/%y |
local_time_fmt |
Local time format |
50 |
%H:%M:%S |
default_date_fmt |
Oracle Default date format |
51 |
DD-MON-YY |
default_time_fmt |
Oracle Default time format |
52 |
HH.MI.SS AM |
language |
Language name |
53 |
AMERICAN |
language_abbr |
ISO abbreviation for language |
54 |
US |
character_set |
Default character set name |
55 |
US7ASCII |
territory |
Default territory name |
56 |
AMERICA |
current_decimal |
Current decimal character |
57 |
. |
current_groupsep |
Current group separator |
58 |
, |
current_currency |
Current local currency |
59 |
$ |
current_date_fmt |
Current Oracle Date format |
60 |
DD-MON-YY |
current_language |
Current language |
70 |
|
current_territory |
Current territory |
61 |
US |
current_character_set |
Current character set |
62 |
US7ASCII |
About the ORA_NLS built-in package
Copyright © 1984, 2005, Oracle. All rights reserved.