PL/SQL Non Equi-Join
Oracle PL/SQL Non Equi-Join
Non Equi-Join is the select query that does not contain the equality operator.
Non Equi-Join Example:
Select o.id, o.customer_id, o.amount From offers o Where o.amount Between 6000 and 100000
Result:
| ID | CUSTOMER_ID | AMOUNT |
| 2 | 1 | 60000.00 |
| 3 | 4 | 45000.00 |
| 4 | 5 | 6000.00 |