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 […]
Month: March 2010
Book review: oracle sql developper
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. […]