Incorrect Columngreenspun.com : LUSENET : DBAzine : One Thread
I have 2 tables with same column name for eg.
Table pqr with column name a create table pqr (a varchar2(16));
Table xyz with column name b
create table xyz (b varchar2(16)); While querying if
select * from pqr where a in (select d from xyz);
This query return all the rows from pqr instead of giving error for incorrect column even thought the column name does n't exist in xyz. Is this a default behaviour of oracle or is it a bug.
-- MILIND ANANT CHARYA (firstname.lastname@example.org), April 04, 2004