OraFAQ Forum: SQL & PL/SQL » Looking for some help with a Compare function.

Home » SQL & PL/SQL » SQL & PL/SQL » Looking for some help with a Compare function. (Oracle 10g, SQL./PLSQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Looking for some help with a Compare function. [message #427645]

Fri, 23 October 2009 13:43

asternmadkatz
Messages: 1
Registered: October 2009
Location: Canada

Junior Member

Am I Crazy?[ 1 vote ]
1.	Yes	1 / 100%
2.	No	0 / 0%
3.	Beyond Crazy!!!	0 / 0%

Ok here is a little background.

I am working with a rather large Oracle 10g DB (talking over 5-600 tables).

I didn't create it...just work with it.

I want to be able to search for differences between 2 entries.

I know what tables I want to look in...keep in mind that there is at least 24 of them right now and each of those table has anywhere between 10-50 columns.

Now between the entries all the columns would be the same, the data within might be different and that is what I want to see. (eg entry one has a date of 5/7/2009 and the other is 1/1/1900).

If the data is the same I don't really care to see it.

I know this function/script is going to be gi-normous, so if you want/need more info I can provide it.

I can get the most of the info required bit by bit, but have no idea how to get it all together and look pretty.

Thanks

Report message to a moderator

Re: Looking for some help with a Compare function. [message #427648 is a reply to message #427645]

Fri, 23 October 2009 14:06

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Poll devoid of interest.

Regards
Michel

Report message to a moderator

Re: Looking for some help with a Compare function. [message #427658 is a reply to message #427645]

Fri, 23 October 2009 15:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I know what a row is.
I know what a column is.

The only way I'd know what an entry is, if one walked up to me & introduced itself.

With 24 tables, you need to do 23 factorial comparisons for each entry.
This does not scale well at all.

Good Luck!

Report message to a moderator

Previous Topic:	Not able to kill Oracle session
Next Topic:	how to know the view's defined on particlular table (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 26 21:20:38 CDT 2025