LvJinYang的博客

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 dua

Navicat导Oracle表结构到Wordcreate or replace view view_table_structure -- 整个库的所有表结构 as select nvl(d.表名, d.列名) 列名, case when d.表名 is null then d.数据类型 else ...