Re: where clause with subquery not returning.

Is it posible that you inserted in the table 'qupload' the name 'QPRICE' with blanks at the end? I can't think of anything else.

screwbai_at_my-deja.com wrote:

> 1) shows me the table_name from ALL_TAB_COLUMNS
> 2) shows me the table_uploadfile from qupload.
> both return the same table_name.
>
> 3) 1+2: I use 2 as a subquery to 1 then NO DICE.
>
> This should be simple andy ideas of what I am doing wrong?
> Also the subquery only returns one line (the qupload table only has one
> row in it).
>
> 1)
> select distinct table_name from ALL_TAB_COLUMNS where
> table_name='QPRICE';
> TABLE_NAME
> ------------------------------
> QPRICE
> 1 row selected.
>
> 2)
> select distinct table_uploadfile from qupload;
> TABLE_UPLOADFILE
> ------------------------------
> QPRICE
>
> 3)
> select * from ALL_TAB_COLUMNS where table_name = (
> select distinct table_uploadfile from qupload);
> OWNER TABLE_NAME
> ------------------------------ ------------------------------
> 0 rows selected.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Sep 28 1999 - 07:40:38 CDT