inconsistent results make me grumpy ( where is the 904? )

From: John Hurley <>
Date: Thu, 30 Jun 2011 12:17:46 -0700 (PDT)
Message-ID: <>

A repost here from my grumpy old dba blog:

inconsistent/unpredictable results make me grumpy ...

Here is a strange one. Why does one query get an ORA-00904 but the same query when used as part of an IN apparently get ignored ( or not noticed as an error )?

This query returns an error:

select table_name from dba_users;
Error at line 1
ORA-00904: "TABLE_NAME": invalid identifier

This query executes ( not very well but ... ): select * from dba_tables where table_name in ( select table_name from dba_users );

This reproduces in and

Is this a well known bug already or ( for some reason ) expected behavior?

I am just starting to research it now ... unfortunately a developer has some bad code running in production with this type of code. Received on Thu Jun 30 2011 - 14:17:46 CDT

Original text of this message