大小写转换

Oracle Sql

select s.* from dev_part_status p right join dev_status_code_info s on p.device_type_code = s.dev_type_code
and p.status_id = s.status_id and LOWER(p.part_type) =LOWER(s.part_type)