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