The NAME_TOKENIZE procedure calls the parser to resolve the specified name into a [. b [. c ]][@ dblink ].
NAME_TOKENIZE removes double quotation marks, converts the name to uppercase if no quotation marks are present, and does not perform semantic analysis. Missing values are retained as NULL.
Note
The DBMS_UTILITY system package of the current version of OceanBase Database does not support the use of UTF16 encoding.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition supports only MySQL mode.
Syntax
DBMS_UTILITY.NAME_TOKENIZE (
name IN VARCHAR2,
a OUT VARCHAR2,
b OUT VARCHAR2,
c OUT VARCHAR2,
dblink OUT VARCHAR2,
nextpos OUT BINARY_INTEGER);
Parameters
| Parameter | Description |
|---|---|
| name | The input name, composed of SQL identifiers (for example, adam.ob@dblink). |
| a | The first token of the name. |
| b | The second token of the name (if applicable). |
| c | The third token of the name (if applicable). |
| dblink | The name of the dblink. |
| nextpos | The position after parsing the input name. |