|
查詢某列是否有空行 select comments from s_org_ext_x t1 where instr(t1.comments,chr(13))>0 or instr(t1.comments,chr(10))>0 更新 update s_org_ext_x t1 set comments=replace(replace(comments,chr(10),''),chr(13),'') where instr(t1.comments,chr(13))>0 or instr(t1.comments,chr(10))>0 |
|
|
來自： soft_xiang > 《我的文章》
