Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I wonder if there is an equally elegant solution for Oracle for the problem posted and answered here:

Comparing Columns that can contain NULLS - is there a more elegant way?

I can't get this solution (the one which was accepted) to work in Oracle environment.

share|improve this question
3  
Oracle has MINUS in place of EXCEPT. –  ypercube Apr 5 '13 at 18:05
    
still doesn't work as shown in the previous quesion when I change that keyword... error is sql command not ended properly. –  robarwebservices Apr 5 '13 at 20:26
    
Ah, yeah, because Oracle doesn't like SELECT without FROM clause. Try ... AND EXISTS(SELECT A.* FROM dual MINUS SELECT B.* FROM dual) –  ypercube Apr 6 '13 at 0:38
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.