Oracle function (converts the entire string to lowercase)

Oracle function (converts the entire string to lowercase) NLS_LOWER (x [, y]) [function] returns the string and converts it to lowercase. [parameter] x-character expression [parameter] Nl

Oracle function (converts the entire string to lowercase) NLS_LOWER (x [, y]) [function] returns the string and converts it to lowercase. [parameter] x-character expression [parameter] Nl

Oracle function (converts the entire string to lowercase)

NLS_LOWER (x [, y])

[Function] returns a string and converts it to lowercase;

[Parameter] x struct expression

[Parameter] Nls_param (optional) specifies the sorting method (nls_sort = ). SCHINESE_RADICAL_M (radical, stroke) SCHINESE_STROKE_M (stroke, radical SCHINESE_PINYIN_M (pinyin ))

[Return] response type

[Example] select nls_LOWER ('AB cde') "test", nls_LOWER ('a c B d E', 'nls _ sort = SCHINESE_PINYIN_M') "test1" from dual;

Return: AB cde, a c B d e