【数据库】case when

select rownum as rn,a.*,
case when depat_nam1 is null then parent_nam else depat_nam1 end as depat_nam