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; 
namespace DB
{
class FunctionFactory;
void registerFunctionLike(FunctionFactory &);
void registerFunctionILike(FunctionFactory &);
void registerFunctionNotLike(FunctionFactory &);
void registerFunctionNotILike(FunctionFactory &);
void registerFunctionMatch(FunctionFactory &);
void registerFunctionExtract(FunctionFactory &);
void registerFunctionReplaceOne(FunctionFactory &);
void registerFunctionReplaceAll(FunctionFactory &);
void registerFunctionReplaceRegexpOne(FunctionFactory &);
void registerFunctionReplaceRegexpAll(FunctionFactory &);
void registerFunctionMultiMatchAny(FunctionFactory &);
void registerFunctionMultiMatchAnyIndex(FunctionFactory &);
void registerFunctionMultiMatchAllIndices(FunctionFactory &);
void registerFunctionMultiFuzzyMatchAny(FunctionFactory &);
void registerFunctionMultiFuzzyMatchAnyIndex(FunctionFactory &);
void registerFunctionMultiFuzzyMatchAllIndices(FunctionFactory &);
void registerFunctionExtractGroups(FunctionFactory &);
void registerFunctionExtractAllGroupsVertical(FunctionFactory &);
void registerFunctionExtractAllGroupsHorizontal(FunctionFactory &);
void registerFunctionsStringRegexp(FunctionFactory & factory)