I do not like this kind of dynamic NOT IN clauses. It is better to have a temporary table, a bit like in
create global temporary table t(x number not null);
insert into t(x) values (:b1);
insert into t(x) values (:b2);
…
insert into t(x) values (:b9999);
select foo from bar where c not in (select x from t);
If you want [...]
Sue Harper is the product manager for Oracle SQL developer. She is also the author of a book, Oracle SQL Developer 2.1 .
A bunch of Oracle blogger received a free online version of the book with the task to write a review.
I have read a few chapters and here are my general comments.
+ The [...]
When I wrote my book, I did not expect having the advanced Oracle sql features available on other dabatase engine.
This week-end I downloaded for fun a try of db2, v9.7.
1) download db2 linux64bit trial on ibm.com
2) install enterprise edition (next-next-install principle)
3) create the instance
4) create the sample database (where database and instance means something [...]