Re: How to match hash_value

It's probably still a white space issue. When I wrote a java-based application to extract and run SQL pulled from v$sqltext_with_newlines, I had to get rid of the nulls (I think) at the end of each line and backspace once at the end of the SQL. I still have the code somewhere if you're interested.

Kevin

On Fri, 2007-02-09 at 13:52 -0700, Allen, Brandon wrote:
> Hi List,
>
> I'm trying to do the ol' stored outline swap-a-roo trick and I'm trying
> to mimic the query coming from an application, but can't get it to come
> out with the exact same hash_value even though I have the exact same
> query text, with the same case and it appears to have the same white
> space as you can see below, so why don't they have the same hash_value?
> Any ideas what I'm missing? I suspect it may be a difference in the
> white spaces, e.g. I have spaces where the original has a tab, but how
> can I find out what the white spaces are supposed to be?
>
> Thanks,
> Brandon
>

--
http://www.freelists.org/webpage/oracle-l