Use and Order Advanced Condition Operators
Use the following order of precedence for the operators you can select when creating an advanced condition.
Order | Operator | Use |
---|---|---|
1 |
|
Use with all fields available in an advanced condition. |
2 |
|
Use with all fields available in an advanced condition. |
3 |
|
Use between queries (AC Library Attributes) |
4 |
|
Use between queries (AC Library Attributes) |
5 |
|
Use between queries (AC Library Attributes) |
Using an INTERSECT, MINUS, or UNION operator results in the creation of two separate select clauses. Therefore, use these operators between different queries.
Be sure to use correct PL/SQL syntax:
SELECT
table1.common_columnFROM
Table1, table2, table3WHERE
Table1.column2 = table2.column2AND
Table2.column3 = table3.column3INTERSECT
SELECT
Table4.common_columnFROM
Table4, table5, table6WHERE
Table4.column2 = table5.column2AND
Table5.column3 = table6.column3
For more information, see: