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

ORA_NLS 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

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

See also

About the ORA_NLS built-in package

ORA_NLS built-in package

ORA_NLS numeric constants

ORA_NLS package examples

About built-in packages