Re: NULL value

nicolas.kaczmarski_at_gmail.com schrieb:
> Hello,
>
> I work on Oracle 10.1
> I would like to delete line in a table where some fields can be "NULL"
>
> EX :
>
> DELETE T_NOTIFICATION
> WHERE DOMAIN_SEQ=p_domain_seq
> AND DATASET_SEQ = p_dataset_seq
> AND COUNTRY_SEQ = p_country_seq
>
>
> The parameters (p_...) can be NULL or not, if they are they must be
> deleted.
> Infortunatly, the test for the NULL value must be like that "myField
> IS NULL" and that doesn't work if field has a value ....
> Have you a good solution?
>

Try this one:

DELETE T_NOTIFICATION
WHERE (DOMAIN_SEQ=p_domain_seq OR p_domain_seq is null) AND (DATASET_SEQ = p_dataset_seq or p_dataset_seq is null) AND COUNTRY_SEQ = p_country_seq or p_country_seq is null)

bon jour

Martin

-- 
Firma/Company:                                              CRESD GmbH
Phone: +49-89-65 30 95 63                      Fax: +49-89-65 30 95 64
WWW:                                               http://www.cresd.de
S-Mail:                               Freibadstr. 14, D-81543 Muenchen

Geschaeftsfuehrer:                     Christina Ragg, Martin Gaeckler
Steuernr.: 143/127/10030                          USt. ID: DE218181906
Handelsregisterblatt:                                  Muenchen 137833
Sitz der Geselschaft:                                         Muenchen

PGP-Key:                            http://www.cresd.de/edv/pgpkey.txt
Open BC (Einladung)            http://www.openbc.com/go/invita/4561755