| ORA-01472: | cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc. | | Cause: | CONNECT BY cannot be used on a view where there is not a correspondence between output rows and rows of the underlying table. | | Action: | Remove the DISTINCT or GROUP BY from the view or move the CONNECT BY clause into the view. |
|
|
