Oracle function (converts the entire string to uppercase)

Oracle function (converts the entire string to uppercase) NLS_UPPER (x [, y]) [function] returns a string and converts the string to uppercase. [parameter] x parameter expression [parameter]

Oracle function (converts the entire string to uppercase) NLS_UPPER (x [, y]) [function] returns a string and converts the string to uppercase. [parameter] x parameter expression [parameter]

Oracle function (converts the entire string to uppercase)

NLS_UPPER (x [, y])

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

[Parameter] x struct expression

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

[Return] response type

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

Return: AB cde, A C B D E

,