oracle| Chinese
Value range: A valid specified value for the parameter.
Default value: NULL
Max_dispatchers:
Description: Specifies the maximum number of scheduler processes that can be run concurrently in a shared server environment.
Value range: Depends on the operating system.
Default value: If the scheduler is configured, the default value is any number greater than 5 or the number of configured schedulers
NLS_NCHAR_CONV_EXCP:
Description: (If the value is TRUE) returns the wrong argument when data is lost in an implicit conversion.
Value Range: FALSE | TRUE
Default value: TRUE
Nls_numeric_characters:
Description: Specifies the characters that will be used as group separators and decimal places. A group separator is used to separate an integer (such as thousand, millions, etc.)
The characters. The decimal separator is used to separate the integer part of a number from the fractional part. Its format is
<decimal_character><group_separator>.
Value range: Any single-byte characters, ' + ', '-', ' < ', ' > ' except.
Default value: Obtained from nls_territory
Nls_sort:
Description: Specifies the order of comparison for an ordered by query. For binary sorting, the order by query's comparison sequence is numerically based. For language sorting,
You will need a full table scan to sort the data according to the language you defined.
Value range: BINARY or a valid language definition name.
Default value: Obtained from Nls_language
Nls_territory:
Description: Specify naming conventions for the following items, including date and week numbers, default date formats, default decimal points characters and group separators, and the default ISO
and local currency symbols. The areas that can be supported include the United States, France and Japan. For information about all areas, see Oracle8i National
Language Support Guide.
Value Range: Any valid region name.
Default value: Depends on the operating system
Nls_timestamp_format:
Description: Similar to Nls_time_format, except that it sets the default value for the TIMESTAMP data type, which stores
Year, MONTH and day these several date values, also store HOUR, MINUTE and SECOND these several time values.
Syntax: TIMESTAMP ' 1997-01-31 09:26:50.10 ' (store value as 11 bytes).
Default value: Obtained from nls_territory
Nls_time_format:
Description: Specifies a string value that sets the default value for the time data type that contains HOUR, MINUTE, and SECOND
These date Time fields.
Syntax: Time ' 09:26:50 ' (store value as 7 bytes).
Default value: Obtained from nls_territory
Nls_time_tz_format:
Description: Specifies a pair of values (UTC,TZD) that sets the default value for the time with ZONE data type that contains
HOUR, MINUTE, SECOND, Timezone_hour and Timezone_minute
These date Time fields. UTC is the world and sometimes TZD is the local time zone.
Syntax: Time ' 09:26:50.20+ 02:00 ' (store value as 9 bytes).
Default value: Obtained from nls_territory
Nls_length_semantics:
Note: Use byte or code point semantics to specify the creation of new columns, such as Char, VARCHAR2, CLOB, nchar, NVARCHAR2,
NCLOB columns. Each character set has its own definition of characters. When using the same character set on both the client and the server,
The string should be measured in characters defined by the character set. The existing columns will not be affected.
Value range: BYTE or CHAR.
Default value: The unit of measure used by characters of the Nls_length_semantics database character set. BYTE.
Nls_date_format:
Description: Specifies the default date format to use with the To_char and to_date functions. The default value for this parameter is determined by the Nls_territory
Are you sure. The value of this parameter can be any valid date format mask contained within double quotes. For example: ' mmm/dd/yyyy '.
Value range: Any valid date format mask, but not more than a fixed length.
Default value: Derived
Nls_timestamp_tz_format:
Description: Similar to Nls_time_tz_format, where a pair of values specifies the default value of the TIMESTAMP data type, which in addition to storing
Year, MONTH and day date values, HOUR, MINUTE and SECOND time values, also stored
Timezone_hour and Timezone_minute.
Syntax: TIMESTAMP ' 1997-01-31 09:26:50+ 02:00 ' (store value as 13 bytes).
Default value: Obtained from nls_territory
Nls_language:
Description: Specifies the default language for 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, Japanese, and so on.
Value range: Any valid language name.
Default value: Depends on the operating system
Nls_comp:
NOTE: In SQL statements, you should avoid using cumbersome nls_sort processes. Under normal circumstances,
Comparisons made in the WHERE clause are binary, but language comparisons require nlssort functions. You can use Nls_comp to specify that you must base
Nls_sort session parameters for language comparisons.
Value range: Any valid 10-byte string specified in the Oracle8i national Language Support Guide.
Default value: BINARY
Nls_currency:
Description: Specifies a string to use as the local currency symbol for the L number format element. The default value for this parameter is determined by Nls_territory.
Value range: Any valid 10-byte string specified in the Oracle8i national Language Support Guide.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
