Check if two “select”s are equivalent

by

If you want to compare the query results try the following:

(select * from query1 MINUS select * from query2) 
UNION ALL
(select * from query2 MINUS select * from query1)

This will result in all rows that are returned by only one of the queries.

More Related Contents:

  1. How can I select from list of values in Oracle
  2. How to kill a running SELECT statement
  3. How do I select all the columns from a table, plus additional columns like ROWNUM?
  4. DATEDIFF function in Oracle [duplicate]
  5. LISTAGG in Oracle to return distinct values
  6. Fetch the row which has the Max value for a column
  7. Oracle SQL: Update a table with data from another table
  8. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Difference between BYTE and CHAR in column datatypes
  11. SQL to generate a list of numbers from 1 to 100
  12. How to use BOOLEAN type in SELECT statement
  13. SQL WHERE ID IN (id1, id2, …, idn)
  14. How to show all privileges from a user in oracle?
  15. SQL – How to select a row having a column with max value [duplicate]
  16. Oracle: loading a large xml file?
  17. IF EXISTS condition not working with PLSQL
  18. Are there any way to execute a query inside the string value (like eval) in PostgreSQL?
  19. Fastest way to determine if record exists
  20. Using pivot on multiple columns of an Oracle row
  21. Solution to “cannot perform a DML operation inside a query”?
  22. Why can’t I seem to force Oracle 11g to consume more CPUs for a single SQL query
  23. How to query a CLOB column in Oracle
  24. Oracle (Old?) Joins – A tool/script for conversion?
  25. Using Alias In When Portion of a Case Statement in Oracle SQL
  26. Oracle string aggregation
  27. Oracle: SQL query to find all the triggers belonging to the tables?
  28. How can I solve ORA-00911: invalid character error?
  29. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment