Re: SQL question
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 14 Oct 2008 08:11:03 -0700
Message-ID: <bf46380810140811y4aaf74f7yb3797850f432910b@mail.gmail.com>
Date: Tue, 14 Oct 2008 08:11:03 -0700
Message-ID: <bf46380810140811y4aaf74f7yb3797850f432910b@mail.gmail.com>
On Mon, Oct 13, 2008 at 5:32 PM, William Wagman <wjwagman_at_ucdavis.edu>wrote:
> Jared,
>
> I'm not sure I understand how that would help, there's no space in the
> data so INSTR(FOO,' ') returns zero. The dump returns this…
>
As others have pointed out, that likely isn't the problem anyway.
The INSTR() function used would only look for spaces.
There are other characters that don't display (tab for instance) and can cause funny things to happen with the data.
DUMP() is how you can see what is really in the data.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 14 2008 - 10:11:03 CDT