Re: View vs. Table

Your example 1 and two are a lot different, example one uses one table, the other one uses a select from a view that is generated from a union operation. You cannot apply the "start with" clause on view with union.

MarcM

Sergey Khochay wrote in 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 - 10:07:17 CDT