Re: View vs. Table

The error message you get is clear:
ORA-01472: cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.

You cannot use connect by with union.
When you use your select statement, the view definition is used to generate the execution plan. A view is not a storage object, it's just a name for a query.

Sergey Khochay a écrit dans le message ...
>Get this
>1. I try to write a query for a tree
>
> select col1, col2, col3 from TABLE1
> start with col3 is null
> connect by col2=col1;
>
> WORKS GOOD
>
>Here is my problem
>
>2. I do the same thing but inted I am selecting from VIEW
> select col1, col2, col3 from VIEW1
> start with col3 is null
> connect by col2=col1;
>
>...and it gives me an ERRORS....
>
>3. My view sound like this
>
>SELECT col1, col2, col3 FROM TABLE_A
>union
>SELECT col1, col2, col3 FROM TABLE_A
>union
>SELECT col1, col2, col3 FROM TABLE_A
>
>
>4. ANY WORD OF WISDOM WHY IT IS WORKING FROM TABLE AND NOT
>WORKING FROM VIEW?????
>
>
Received on Tue Aug 17 1999 - 03:23:23 CDT