Oracle DB Error ORA-01472 cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.

The following in the cause of this error:

CONNECT BY cannot be used on a view where there is not a correspondence between output rows and rows of the underlying table.

Action you can take to resolve this issue: Remove the DISTINCT or GROUP BY from the view or move the CONNECT BY clause into the view.

Tags: Database, Education, Software

Related