Incorrect Column

greenspun.com : LUSENET : DBAzine : One Thread

Hi,

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 (milind_charya@yahoo.com), April 04, 2004


Moderation questions? read the FAQ