ORA-02014: cannot select FOR UPDATE from view

I got ” ORA-02014: cannot select FOR UPDATE from view ”  error in Oracle database.

 

ORA-02014: cannot select FOR UPDATE from view

 

Details of error are as follows.

ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY

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.

 

 

cannot select FOR UPDATE from view with DISTINCT, GROUP BY

This ORA-00704 is related with the 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.

To solve this error, Do not use SELECT… FOR UPDATE on this view.

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

See more