Geek asks and answers

Oracle Debugging Technology for Line Difference

I run a production request and it returns me 500 lines and I have the same copy on my dev and the request returns only 497 lines.

What approach or steps can be taken to compare the results?

Is there a tool?

+3
source share
2 answers

Assuming there is a connection between the two databases and that the returned data matches most rows, you can use the MINUS operation. Sort of

SELECT list_of_columns
  FROM some_table
 WHERE some_criteria
MINUS
SELECT list_of_columns
  FROM some_table@db_link_to_dev
 WHERE some_criteria

, , , . . , , , .

+4

, WinMerge . . , WinMerge .

: , . A * nix .

+2

More articles:


All Articles