特殊字符处理 UTL_RAW.CAST_TO_RAW dblink乱码也可以

2023-12-13 07:10:27

Accidentally created a service name via DBMS_SERVICE.CREATE_SERVICE which contains a special character that's not?displaying correctly.

SOLUTION

Cast the whole service name in raw using UTL_RAW package and delete statement while issuing the raw string as input in a UTL_RAW.CAST_TO_VARCHAR2 function.

This?should?delete it:

SELECT?UTL_RAW.CAST_TO_RAW(NAME) FROM ALL_SERVICES?WHERE NAME LIKE '<READABLE_SERVICE_NAME>%';

EXEC DBMS_SERVICE.DELETE_SERVICE(UTL_RAW.CAST_TO_VARCHAR2('<RESULT FROM ABOVE>'));

文章来源:https://blog.csdn.net/jnrjian/article/details/134917528
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。