Forum Discussion

sshaik's avatar
sshaik
New Contributor III
3 years ago
Solved

Unique Constraint Issue in Oracle while inserting Data

In this Scenario, I have to insert data onto an Oracle DB. Before that one I’m performing a Left Outer join and separating the data (for Update and Insert) by using router. In Insert snap I have to i...
del's avatar
del
Contributor III
3 years ago
Copy Link

@sshaik, I don’t have an Oracle DB with which I can test this suggestion, so consider it with that disclaimer; but I think what you may need to do is modify your WHERE query to be a NOT EXISTS subquery.

Something similar too:

WHERE NOT EXISTS (SELECT NULL FROM Schema.tablename WHERE DEST = $DEST AND LVL = $LVL)