Question

oracle数据库怎样当字符串只有为空时才更新的语句

Answer 1

update 表 set 字段＝值 where 字段 is null

Answer 2

update table set fd=nvl(fd,'your new value') where....

Answer 3

update table_name set col_name = '' where col_name is null or col_name = '';