https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions196.htm

eg.

SELECT TRANSLATE('SQL*Plus User''s Guide', ' */''', '___') ;
returns
SQL_Plus_Users_Guide  

the characters arguments maybe utf8, so

TRANSLATE('哈哈(吗)', ' ()', '【】)
returns
哈哈【吗】

my ugly sql:
SELECT arrayStringConcat(
arrayMap(x-> case when x in ['(',')'] then ['【','】'][indexOf(['(',')'],x)] else x end, splitByRegexp('','哈哈(吗)')) 
)
as res; 
{
    registerFunctionLike(factory);
    registerFunctionILike(factory);
    registerFunctionNotLike(factory);
    registerFunctionNotILike(factory);
    registerFunctionMatch(factory);
    registerFunctionExtract(factory);
    registerFunctionReplaceOne(factory);
    registerFunctionReplaceAll(factory);
    registerFunctionReplaceRegexpOne(factory);
    registerFunctionReplaceRegexpAll(factory);
    registerFunctionMultiMatchAny(factory);
    registerFunctionMultiMatchAnyIndex(factory);
    registerFunctionMultiMatchAllIndices(factory);
    registerFunctionMultiFuzzyMatchAny(factory);
    registerFunctionMultiFuzzyMatchAnyIndex(factory);
    registerFunctionMultiFuzzyMatchAllIndices(factory);
    registerFunctionExtractGroups(factory);
    registerFunctionExtractAllGroupsVertical(factory);
    registerFunctionExtractAllGroupsHorizontal(factory);
}
}