Any Oracle/SQL gurus out there?

tjjeepjeep · 03-17-2010, 02:23 PM

Looking for some geeks to help me. Here's my dilemma. Upgrading a translation software and need to ensure the Oracle output is the same. So something like showing column differences for two specific rows in an Oracle table within the same database. So first row is a baseline of the file ran in production; second row is the same file ran through new version. Want the column diffs to ensure it's translating to same columns. I have been playing with SQL and think it should be able to do it. Anyone?? Let me know

KargoMaster · 03-17-2010, 03:03 PM

{geek}

I can modify SQL queries with some proficiency... but the Oracle piece... I got nothing... sorry.

{/geek}

tjjeepjeep · 03-17-2010, 03:09 PM

what command would you use to do a compare?

compare

diff

??

KennyTJ · 03-17-2010, 07:00 PM

I think you need to use the "create table" function... I'm no master though, and hate when I have to get into the SQL database directly.. :p

Good luck!

TomH · 03-17-2010, 07:16 PM

A down and dirty method would be to concatenate the values of all columns into a single column in copies of both the original and upgraded tables. Query the upgraded table using the concatenated value(s) from the original table.

If it finds the value in the upgraded copy, you're golden.

Good luck.

TomH · 03-23-2010, 05:51 PM

Soooooooooooooooooooo, how did this turn out?:confused:

tjjeepjeep · 03-24-2010, 08:08 AM

I asked the 'experts' here at work and after 3 days no real answer... they suggest using Access. I just can't believe I'm the only person in the world needing to compare all columns within two rows in a single Oracle table and spit out differences. I find things to compare entire tables, but nothing that isolates down two rows. I'm still working on it...They frown on users creating tables but I'm about to where if I get it working they're gonna deal with how I got there.. More to come

KennyTJ · 03-24-2010, 08:30 PM

Quote:

Originally Posted by tjjeepjeep

I asked the 'experts' here at work and after 3 days no real answer... they suggest using Access.

WOW... take a deep breath, now let it out.... now repeat.....

LOL

I use SQL for all my engineering stuff... good luck!

03-17-2010, 02:23 PM	#1
tjjeepjeep Just tired Join Date: Apr 2007 Location: Hamilton, OH Posts: 2,213 Images: 2212	Any Oracle/SQL gurus out there? Looking for some geeks to help me. Here's my dilemma. Upgrading a translation software and need to ensure the Oracle output is the same. So something like showing column differences for two specific rows in an Oracle table within the same database. So first row is a baseline of the file ran in production; second row is the same file ran through new version. Want the column diffs to ensure it's translating to same columns. I have been playing with SQL and think it should be able to do it. Anyone?? Let me know __________________ I want to be the reason you look down at your phone and smile........then walk into a pole.

03-17-2010, 03:03 PM	#2
KargoMaster Cleaning off the rust... Join Date: Jan 2007 Location: Cincinnati, OH Posts: 1,009	{geek} I can modify SQL queries with some proficiency... but the Oracle piece... I got nothing... sorry. {/geek} __________________ brad 5.0L \| 435 \| 203 \| 300 \| 4.10 \| 39.5 Buildup BACK underway...

03-17-2010, 03:09 PM	#3
tjjeepjeep Just tired Join Date: Apr 2007 Location: Hamilton, OH Posts: 2,213 Images: 2212	what command would you use to do a compare? compare diff ?? __________________ I want to be the reason you look down at your phone and smile........then walk into a pole.

03-24-2010, 08:08 AM	#7
tjjeepjeep Just tired Join Date: Apr 2007 Location: Hamilton, OH Posts: 2,213 Images: 2212	I asked the 'experts' here at work and after 3 days no real answer... they suggest using Access. I just can't believe I'm the only person in the world needing to compare all columns within two rows in a single Oracle table and spit out differences. I find things to compare entire tables, but nothing that isolates down two rows. I'm still working on it...They frown on users creating tables but I'm about to where if I get it working they're gonna deal with how I got there.. More to come __________________ I want to be the reason you look down at your phone and smile........then walk into a pole.

03-17-2010, 07:00 PM	#4
KennyTJ The Pirate Join Date: Oct 2007 Location: Lebanon, Oh. Posts: 297	I think you need to use the "create table" function... I'm no master though, and hate when I have to get into the SQL database directly.. :p Good luck!

03-17-2010, 07:16 PM	#5
TomH Gearhead Join Date: Mar 2008 Location: Anderson Posts: 95	A down and dirty method would be to concatenate the values of all columns into a single column in copies of both the original and upgraded tables. Query the upgraded table using the concatenated value(s) from the original table. If it finds the value in the upgraded copy, you're golden. Good luck.

03-23-2010, 05:51 PM	#6
TomH Gearhead Join Date: Mar 2008 Location: Anderson Posts: 95	Soooooooooooooooooooo, how did this turn out?:confused: