Condição para select no Oracle

[Motta 645]

Já fiz vários selects parecidos , sempre funcionou , segue um exemplo para a user-tab_columns

/*TABELAS QUE TEM 3 TIPOS DE TYPE CHARB,DATE E NUMBER*/
SELECT TABLE_NAME
FROM   USER_TAB_COLUMNS
WHERE  DATA_TYPE IN ('CHAR','DATE','NUMBER')
GROUP BY TABLE_NAME
HAVING COUNT(DISTINCT DATA_TYPE) = 3
ORDER BY 1

/*TODOS OS CAMPOS DESTA TABELA*/
SELECT *
FROM   USER_TAB_COLUMNS
WHERE  DATA_TYPE IN ('CHAR','DATE','NUMBER')
AND    TABLE_NAME IN (SELECT TABLE_NAME
                      FROM   USER_TAB_COLUMNS
                      WHERE  DATA_TYPE IN ('CHAR','DATE','NUMBER')
                      GROUP BY TABLE_NAME
                      HAVING COUNT(DISTINCT DATA_TYPE) = 3)
ORDER BY 1