IN/NOT IN Parsing
Date: 24 Oct 2008 10:00:37 GMT
I'd never noticed until today that Oracle doesn't check if columns used in an in/not in clause are valid. Is this common knowledge that I've somehow missed out on?
Strikes me as being very dangerous as you could typo a column name & never know about it - at least not until your data was already screwed up.
create table t1 (id1 number);
create table t2 (id1 number, id2 number);
insert into t1 values(1);
insert into t2 values(1,1);
insert into t2 values(1,2);
select * from t2
where id2 in (select id2 from t1);
-- PrestonReceived on Fri Oct 24 2008 - 05:00:37 CDT