List of Examples
- 3-1 Setting NLS_LANG to American_America.WE8ISO8859P1
- 3-2 Setting NLS_LANG to French_France.WE8ISO8859P1
- 3-3 NLS_LANGUAGE=ITALIAN
- 3-4 NLS_LANGUAGE=GERMAN
- 3-5 NLS_LANGUAGE=AMERICAN, NLS_TERRITORY=AMERICA
- 3-6 NLS_LANGUAGE=AMERICAN, NLS_TERRITORY=GERMANY
- 3-7 NLS_LANGUAGE=GERMAN, NLS_TERRITORY=GERMANY
- 3-8 NLS_LANGUAGE=GERMAN, NLS_TERRITORY=AMERICA
- 3-9 NLS_LANG=ITALIAN_ITALY.WE8DEC
- 3-10 Change Language, Date Format, and Decimal Character
- 3-11 Setting the Date Format to Display Roman Numerals
- 3-12 NLS_DATE_LANGUAGE=FRENCH, Month and Day Names
- 3-13 NLS_DATE_LANGUAGE=FRENCH, Month and Day Abbreviations
- 3-14 NLS_DATE_LANGUAGE=FRENCH, Default Date Format
- 3-15 Timestamp Format
- 3-16 Setting NLS_TIMESTAMP_TZ_FORMAT
- 3-17 NLS_CALENDAR='English Hijrah'
- 3-18 Setting NLS_NUMERIC_CHARACTERS
- 3-19 Displaying the Local Currency Symbol
- 3-20 Setting NLS_ISO_CURRENCY
- 3-21 Setting NLS_SORT
- 4-1 Inserting Data into a DATE Column
- 4-2 Inserting Data into a TIMESTAMP Column
- 4-3 Inserting Data into the TIMESTAMP WITH TIME ZONE Datatype
- 4-4 Inserting Data into the TIMESTAMP WITH LOCAL TIME ZONE Datatype
- 4-5 Converting a Datetime Value to Another Time Zone
- 4-6 Comparing Daylight Saving Time Calculations Using TIMESTAMP WITH TIME ZONE and TIMESTAMP
- 4-7 Comparing Daylight Saving Time Calculations Using TIMESTAMP WITH LOCAL TIME ZONE and TIMESTAMP
- 4-8 Daylight Saving Time Is Not Calculated for Regions That Do Not Use Daylight Saving Time
- 5-1 Linguistic Sort Using Base Letters, Diacritics, Punctuation, and Case Information
- 5-2 Case-Insensitive Linguistic Sort
- 5-3 Accent-Insensitive Linguistic Sort
- 5-4 Binary Sort
- 5-5 Monolingual German Sort
- 5-6 Comparing a Monolingual German Sort to a Multilingual Sort
- 5-7 Binary Comparison Binary Sort
- 5-8 Linguistic Comparison Binary Case-Insensitive Sort
- 5-9 Linguistic Comparison Binary Accent-Insensitive Sort
- 5-10 Linguistic Comparisons Returning Fewer Rows
- 5-11 Linguistic Comparisons Using XSPANISH
- 5-12 Case-Insensitive Match Using the NLS_SORT Value
- 5-13 Case Insensitivity Overridden by the Runtime Match Option
- 5-14 Matching with the Collation Element Operator [..]
- 5-15 Matching with the Character Class Operator [::]
- 5-16 Matching with the Base Letter Operator [==]
- 6-1 Creating a Database with a Unicode Character Set
- 6-2 Creating a Database with a National Character Set
- 6-3 Unicode Solution with a Unicode Database
- 6-4 Unicode Solution with Unicode Datatypes
- 6-5 Unicode Solution with a Unicode Database and Unicode Datatypes
- 7-1 Populating the Customers Table Using the TO_NCHAR Function
- 7-2 Selecting from the Customer Table Using the TO_CHAR Function
- 7-3 Selecting from the Customer Table Using the TO_DATE Function
- 7-4 INSTR Function
- 7-5 CONCAT Function
- 7-6 RPAD Function
- 8-1 HelloWorld JSP Page Code
- 8-2 HelloWorld web.xml Code
- 8-3 The GDK-enabled web.xml File
- 8-4 GDK Configuration File gdkapp.xml
- 8-5 Enabled HelloWorld JSP
- 8-6 Constructing the Locale Selection List
- 9-1 Specifying a German Sort with the NLS_SORT Session Parameter
- 9-2 Specifying a French Sort with the NLSSORT Function
- 9-3 Making a Linguistic Comparison with the WHERE Clause
- 12-1 Specifying Only the File Name in the LCSSCAN Command
- 12-2 Specifying the Format as HTML
- 12-3 Specifying the RESULTS and BEGIN Parameters for LCSSCAN
- 12-4 Specifying the RESULTS and END Parameters for LCSSCAN
- 12-5 Specifying the BEGIN and END Parameters for LCSSCAN
