Re: where clause with subquery not returning.

Is table_uploadfile in your table defined as CHAR or VARCHAR? If it is CHAR, spaces will be inserted at the end of your string to make up the field length whereas VARCHAR2 will not have spaces. If it is VARCHAR2, the only other sugestion is that you accidently input the tablename with a trailing space or two

M

> > 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 - 09:48:12 CDT