Oracle DB Error ORA-02014 cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

The following is the cause of this error:

An attempt was made to SELECT... FOR UPDATE from a view whose defining SELECT statement uses at least one of the following constructs in its outer block: outer join, GROUP BY clause, aggregate functions, SELECT DISTINCT, CONNECT BY clause, or set operation, UNION, INTERSECT, or MINUS.

Action you can take to resolve this issue: Do not use SELECT... FOR UPDATE on this view.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related