SQL的坑length(trim(null))

SQL的坑length(trim(null))

起因：测试的时候没有拿到对应的数据

select  case when length(trim('XN00901001,XN0090'))>length(trim(null)) then 'XN00901001,XN0090' else null end as custids from dual;

这种会返回null，不会返回XN00901001,XN0090

需要改为

select nvl(length(trim(null)),0) from dual;

select  case when nvl(length(trim('XN00901001,XN0090')),0) > nvl(length(trim(null)),0) then 'XN00901001,XN0090' else null end as custids from dual;