The NAME_TOKENIZE stored procedure calls the parser to parse a specified name into the a [. b [. c ]][@ dblink ] pattern.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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 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. |