IN/NOT IN Parsing
From: Preston <dontwantany_at_nowhere.invalid>
Date: 24 Oct 2008 10:00:37 GMT
Message-ID: <6mdkm5Fgfpm8U1@mid.individual.net>
Date: 24 Oct 2008 10:00:37 GMT
Message-ID: <6mdkm5Fgfpm8U1@mid.individual.net>
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);
commit;
select * from t2
where id2 in (select id2 from t1);
-- PrestonReceived on Fri Oct 24 2008 - 05:00:37 CDT