Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem querying a view

Re: Problem querying a view

From: teresa <pixelmeow_at_gmail.com>
Date: Mon, 11 Jun 2007 19:31:12 -0000
Message-ID: <1181590272.413329.28170@w5g2000hsg.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US