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

ORA_NLS 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

sign_placement

Sign location: 0=before, 1=after

64

initcap_month

Initcap month names: 0=NO,1=YES

65

initcap_day

Initcap 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

See also

About the ORA_NLS built-in package

ORA_NLS built-in package

ORA_NLS character constants

ORA_NLS built-in package examples

About built-in packages