Value range: Valid specified value for parameters.
Default: null
Max_dispatcher:
Note: Specifies the maximum number of scheduler processes that can run simultaneously in a shared server environment.
Value range: Depending on the operating system.
Default: If the scheduler is configured, the number of default values greater than 5 or the number of schedulers configured.
NLS_NCHAR_CONV_EXCP:
Description: (If true ") Returns the error parameters when data is lost in implicit conversions.
Value range: false | TRUE
Default: True
NLS_NUMERIC_CHARACTERS:
Note: Specifies the character that will be used as a group separator and a decimal bit. Component jaw is used to separate a number of groups (such as thousands, millions, etc.)
character of. The decimal separator is used to separate a number of integers into the decimal portion. The format is
Value range: Any single-by-stroke character, ' ', '-', except '<', '>' except.
Default: get from NLS_TERRITORY
NLS_SORT:
Description: Specifies the comparison order of the ORDER BY query. For binary sorting, the comparison order of the ORDER BY query is based on the value. For language sorting,
The full surface scan is required to sort the data according to the defined language.
Value range: binary or valid language definition name.
Default: get from NLS_LANGUAGE
NLS_TERRITORY:
Description: Specify naming conventions for the following, including the date and week number, default date format, default decimal point character, and component jaw, and default ISO
And local currency symbols. Supported areas include the United States, France and Japan. For information on all regions, see Oracle8i National National
Language support guide.
Value range: Any valid area name.
Default: Depending on the operating system
NLS_TimeSTAMP_FORMAT:
Description: Similar to NLS_TIME_FORMAT, but it sets the default value of the TimeStamp data type, the data type is stored
These dates values for Year, Month and Day, also store HOUR, Minute, and Second.
Syntax: TimeStamp '1997-01-31 09: 26: 50.10' (stored in 11 bytes).
Default: get from NLS_TERRITORY
NLS_TIME_FORMAT:
Description: Specify a string value, set the default value of the TIME data type, which contains Hour, Minute and SECOND
These date time fields.
Syntax: Time '09: 26: 50 '(stores the value to 7 bytes).
Default: get from NLS_TERRITORY
NLS_TIME_TZ_FORMAT:
Description: Specify a pair of values (UTC, TZD), set the default value of the Time with time zone data type, the data type contains
Hour, minute, second, timezone_HOUR and TIMEZONE_MINUTE
These date time fields. UTC is the world and TZD is the local time zone.
Syntax: Time '09: 26: 50.20 02:00 '(stored in 9 bytes).
Default: get from NLS_TERRITORY
NLS_LENGTH_SEMANTICS:
Note: Use bytes or code points to specify the creation of the new column, such as Char, Varchar2, Clob, Nchar, NVARCHAR2,
Nclob column. Various character sets have their own definitions. When using the same character set on the client and server,
The string should be measured in the character set by the character set. Existing columns will not be affected.
Value range: byte or char.
Default: NLS_LENGTH_SEMANTICS's database character set of metric units. Byte.
NLS_DATE_FORMAT: Description: Specifies the default date format used to use with the to_CHAR and TO_DATE functions. The default value of this parameter is from NLS_TERRITORY
determine. The value of this parameter can be any valid date format mask included in the double quotation number. For example: '' MMM / DD / YYYY ''.
Value range: Any valid date format mask, but must not exceed a fixed length.
Default: derived
NLS_TimeStamp_TZ_FORMAT:
Description: Similar to NLS_TIME_TZ_FORMAT, a pair of values specify the default value of the TimeSTAMP data type, which is stored
Year, Month and Day date values, Hour, Minute, and Second time value, also stored
Timezone_Hour and Timezone_Minute.
Syntax: TimeStamp '1997- 01-31 09: 26: 50 02:00' (stored as 13 bytes).
Default: get from NLS_TERRITORY
NLS_LANGUAGE:
Description: Specify the default language of the database, which will be used for messages, date, and month names, AD, BC, AM, and PM symbols.
And the default sorting mechanism. Supported languages include English, French and Japanese, and more.
Value range: Any valid language name.
Default: Depending on the operating system
NLS_COMP:
Note: In the SQL statement, you should avoid the use of cumbersome NLS_SORT processes. Under normal circumstances,
The comparison in the WHERE clause is binary, but the language comparison requires the NLSSort function. You can use NLS_COMP to specify must
The NLS_SORT session parameters are compared.
Value range: Any valid 10-byte string specified in Oracle8i National Language Support Guide.
Default: binary
NLS_CURRENCY:
Description: Specifies a string used as a local currency symbol for the L number format element. The default value of this parameter is determined by NLS_TERRITORY.
Value range: Any valid 10-byte string specified in Oracle8i National Language Support Guide.
Default: get from NLS_TERRITORY
