ORA-01472
cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.
Cause
CONNECT BY could not be used on a view where there was 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.
ORA-01472
cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.
Cause
CONNECT BY could not be used on a view where there was 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.
ORA-01472
cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.
Cause
CONNECT BY could not be used on a view where there was 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.
