Sql Server、Oracle以及Access数据库 判断字段是否为空的办法
Oracle :
Nvl
select userName,IIF(address is null,'无',address) from [user]...
select userName,IIF(address is null,'没写','写了') from [user]...
Nvl
select userName,IIF(address is null,'无',address) from [user]...
select userName,IIF(address is null,'没写','写了') from [user]...