| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
|
lnnvl [Oracle SQL] | ||
... where lnnvl(condition)... create table lnnvl_ex ( a number, b number ); insert into lnnvl_ex values (null, null); insert into lnnvl_ex values (null, 1); insert into lnnvl_ex values ( 2, 2); insert into lnnvl_ex values ( 3, null); insert into lnnvl_ex values ( 4, 5); select * from lnnvl_ex where a=b;
A B
---------- ----------
2 2
select * from lnnvl_ex where lnnvl(a=b);
A B
---------- ----------
1
3
4 5
Links |