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 Case-Insensitive Match Using the NLS_SORT Value

5-8 Case Insensitivity Overridden by the Runtime Match Option

5-9 Matching with the Collation Element Operator [..]

5-10 Matching with the Character Class Operator [::]

5-11 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 Customer 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

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 RESULTS and BEGIN Parameters for LCSSCAN

12-3 Specifying the RESULTS and END Parameters for LCSSCAN

12-4 Specifying the BEGIN and END Parameters for LCSSCAN