Oracle Database SQL - Minus

Card Puncher Data Processing

About

Relational Operator - Set-Difference (Except/Minus) in Oracle.

Support

ORA-00907: missing right parenthesis

ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:
Error at Line: 72 Column: 6

Verify that you don't have an ORDER BY clause in one of your query.





Discover More
Relational Algebra Between Sql And Query Plan
Relational Operator - Set-Difference (Except/Minus)

in Relational Operator set-difference is a relational operator that takes all Tuples in the relation 1, but not in relation 2 It's also known as: except, or minus It returns all tuples (row)...



Share this page:
Follow us:
Task Runner