You can call the CLEAR_IDENTIFIER procedure to set the identifier of the current session to NULL.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SESSION.CLEAR_IDENTIFIER;
Considerations
The CLEAR_IDENTIFIER procedure can be executed by using the PUBLIC keyword.
Examples
BEGIN
DBMS_SESSION.CLEAR_IDENTIFIER;
END;