Oracle NULLを含むWHERE条件

2月 23rd, 2011

ちょいちょい使うのでメモ。

SELECT *
FROM TEST t
WHERE
(t.DATA = '条件値' 
 OR t.DATA IS NULL AND '条件値' IS NULL)
Dim sql As New StringBuilder()
sql.Append(" SELECT * FROM TEST t WHERE ")
sql.Append(String.Format("(t.DATA = '{0}' OR t.DATA IS NULL AND '{0}' IS NULL)", "条件値"))

VB.NETで書くとこんな感じ?
動作確認はしてないです

Posted in ProgramingNo Comments

Leave a Comment