A script-enabled browser is required for this page to function properly.

ORA_PROF Constants

Numeric Constants

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

Character Constants

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