Use the following constants to retrieve numeric information about the current language. All of the constants are of type PLS_INTEGER, with each assigned an integer value.
Name | Description | Integer |
---|---|---|
decimal_places | Currency Decimal Places | 63 |
Integer | Sign location: 0=before, 1=after | 64 |
initcap_month | Initcap month names: 0=NO,1=YES | 65 |
initcap_day | nitcap day names: 0=NO,1=YES | 66 |
week_start | Week start day: 0=sunday | 67 |
week_num_calc | Week num calc: 1=ISO, 0=non ISO | 68 |
iso_alphabet | Current ISO alphabet number | 69 |
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 | 26 |
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 | 70 | DD-MON-YY |
current_language | Current language | 60 | |
current_territory | Current territory | 61 | US |
current_character_set | Current character set | 62 | US7ASCII |