THERE YOU GO, OLD CRANKY


SQL> select * from foo where f2 is null;

F1 F2
--------- --------------------
2

SQL> delete from foo
2 where f1 in (
3 select f1 from foo
4 where not (f2 between '0' and '9') or f2 is null
5 );

1 row deleted.

SQL> select * from foo;

no rows selected

SQL>