| ORA-02014: | cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. | | Cause: | 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: | Do not use SELECT... FOR UPDATE on this view. |
|
|