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_UTILITY package does not support the UTF-16 character set.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the 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, which consists of SQL identifiers. For example, adam.ob@dblink. |
| a | The output for the first token of the name. |
| b | The output for the second token of the name (if applicable). |
| c | The output for the third token of the name (if applicable). |
| dblink | The output for the DBLink of the name. |
| nextpos | The next position after the input name is parsed. |