/*
单行函数
1.字符函数
*/
select upper(‘aaBBcc’),lower(‘AAbbCC’),initcap(‘WoShiHe guan Hong’);
select ‘111’||‘2222’,char_length(‘heg’),length(‘3333’),trim(both ‘x’ from ‘xaaxbbxccx’);
select ltrim(‘213adawd321’,‘123’);
select rtrim(‘21a3adawd3421’,‘123’);
select substring(‘abcdefg’,2,2);
select to_hex(1234);
select lpad(‘1234.00’,10,’*’);
select rpad(‘1234.00’,10,’-’);
select replace(‘aaa111aabbaaddaa’,‘aa’,’*’);