Any Oracle/SQL gurus out there?

[tjjeepjeep]

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]

{geek}

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

{/geek}

:beers:

[tjjeepjeep]

what command would you use to do a compare?

compare

diff

??

[KennyTJ]

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]

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]

Soooooooooooooooooooo, how did this turn out?:confused:

[tjjeepjeep]

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]

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..... :D LOL

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

:beers: