Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Result return values even when the column name are not there

Trilochan NayakJan 7 2025

I have 2 Tables ex

Create Table Test_A (Col1 VarChar2(256), Col2 VarChar2(256))

Insert Into Test_A Values('A','B');

Insert Into Test_A Values('C','D');

Create Table Test_B (Col3 VarChar2(256))

Insert Into Test_B Values('E')

Select * From Test_A Where Col2 IN(Select Col2 From test_B)

Now my table Test_B doesnot have Col2 but still the above query is executed and returns all records of Test_A table

Added on Jan 7 2025

2 comments

132 views