查詢的某字段不為空的寫法
SELECT
i.zch zch,
i.zzmc zzmc,
i.longtitude qydzX,
i.latitude qydzY
FROM
ind_qyzt_jbxx i
WHERE i.sfgsqy = '1'
AND (i.zch IS NOT NULL
AND i.zch != '')
查詢的某字段不為空的寫法
SELECT
i.zch zch,
i.zzmc zzmc,
i.longtitude qydzX,
i.latitude qydzY
FROM
ind_qyzt_jbxx i
WHERE i.sfgsqy = '1'
AND (i.zch IS NOT NULL
AND i.zch != '')
![Oracle通過case when條件判斷和instr字元串查找修改查詢結果[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)