code_tbl description:

Name Null? Type
----------------------------------------- -------- ----------------------------
CDE1 NOT NULL CHAR(1)
CDE3 CHAR(4)
CDE2 CHAR(2)


sample data in table:

cde1 cde3 cde2
---- ---- ----
1 ab
2 1111
3 1234 cd
4 1234 de

Please note that I have nulls in col2 & col3. database is ORACLE.

How do I delete the data from code_tbl wherein I have to use all of the column names in where clause.

Please suggest me the correct SQL query.

I am trying to use following SQL but it is not deleting the row.

SQL> delete from code_tbl where cde1 = '1' and cde2 = 'NY' and cod3 = null;

Thanks in advance,
KNS

... and cod3 is null

delete from code_tbl where cde1 = '1' and cde2 = 'ab' and cod3 = null;

I can't hard-code "cde3 is null" because sometimes i will be having value in that and if i have values...I got to use that in my query. Please suggest.

Thanks

write an IF statement in whatever application language is calling the database