Oracle 大小写转换函数

Oracle 大小写转换函数

转大写UPPER

转小写LOWER

应用：
select UPPER(‘Test’) as u from dual;
SELECT * FROM Dba_Dependencies a WHERE a.referenced_name=UPPER(‘t_policy’) ;
select LOWER(‘Test’) as l from dual;