Re: How to match hash_value
- From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Fri, 09 Feb 2007 14:31:47 -0700
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
