Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem querying a view
On Jun 11, 3:03 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jun 11, 1:53 pm, teresa <pixelm..._at_gmail.com> wrote:
> > On Jun 11, 2:44 pm, teresa <pixelm..._at_gmail.com> wrote:
<lawnmower>
> You likely have trailing spaces on the USER_ID values and, as such,
> nothing is equal to your 'truncated' string. Try this and see what is
> returned:
>
> select '||user_id||' user_id
> from
> (select distinct user_id from ta);
>
> You may be surprised at what you find.
>
> David Fitzjarrell-
Once again you have saved the day. I am now getting the results I
expected. Thank you so much!
teresa
Received on Mon Jun 11 2007 - 14:31:12 CDT
![]() |
![]() |