The NAME_TOKENIZE stored procedure calls the parser to parse a specified name into the a [. b [. c ]][@ dblink ] pattern. The NAME_TOKENIZE stored procedure removes double quotation marks ("). If no quotation marks exist, it converts the data into uppercase without semantic analysis. Missing values are retained as NULL.
Note
In the current OceanBase Database version, the
DBMS_UTILITYpackage does not support the UTF-16 character set.
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, which consists of SQL identifiers. For example, adam.ob@dblink. |
| a | The first token of the output name. |
| b | The second token of the output name (if applicable). |
| c | The third token of the output name (if applicable). |
| dblink | The output for the dblink of the name. |
| nextpos | The next position after the input name is parsed. |