使用trim函数将字符串’hello’、"?Hello?‘分别处理得到下列字符串ello、Hello SELECT
LTRIM(‘hello’,‘h", FROM DUAL;
SELECT
TRIM(’?’ FROM '?Hello?") FROM DUAL;
oracle去除左右两边指定字符
最新推荐文章于 2024-03-13 23:23:04 发布
使用trim函数将字符串’hello’、"?Hello?‘分别处理得到下列字符串ello、Hello SELECT
LTRIM(‘hello’,‘h", FROM DUAL;
SELECT
TRIM(’?’ FROM '?Hello?") FROM DUAL;