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:

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-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: