QUESTION POSED ON: 17 April 2008
I'm trying to write an Oracle SQL statement where I'm extracting the
name of the table from USER_TAB_COLUMNS, and within the same SQL
statement determine if an attribute value from those tables returned by
the first query has values. For example:
select a.* from
( select TABLE_NAME
from USER_TAB_COLUMNS
where COLUMN_NAME='HGT') a
where HGT is not null;
There is obviously something wrong with the syntax of this SQL, because
I get an Oracle error, ORA-00904, saying that the HGT is an invalid
identifier.
|
