--当左边字符不够指定位数时,按右边的值自动补齐致指定位数
select rpad('31.345',9,'00000') from dual;
--当右边字符不够指定位数时,按右边字符循环,最后再拼接上左边字符串;
select lpad('123',7,'456') from dual; --替换掉字符串中前后指定的字符
select trim( trailing ',' from '12312,,,31312,') from dual;
--替换掉右边的指定字符(只能替换掉右边的字符)
select rtrim(',342,dafdccc,,,,,,,,',',') from dual; select rtrim(',,,,12312,,,31312','312'),trim( trailing '312' from ',,,,12312,,,31312') from dual;
trim( trailing ',' from '12312,,,31312,') 和 rtrim(',342,dafdccc,,,,,,,,',',') 两种函数功能一样,但 trim函数只能替换首尾一个字符;而rtrim可指定多个字符;