Incorrect Column : 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 (, April 04, 2004

Moderation questions? read the FAQ