Re: feature & performance comparison

On Sat, 09 Jun 2001 20:19:31 -0400, Thomas Kyte wrote:
>
> scott_at_ORA8I.WORLD> select lpad(' ',(level-1)*2,' ') || ename ename
> 2 from emp
> 3 start with mgr is null
> 4 connect by prior empno = mgr;

[...]

I'm curious: where does this 'level' come from? I assume it's an implicit value somehow related to the "connect by" clause. What happens if the 'emp' table has a column named 'level'?

-- 
Knut Stolze
DB2 UDB Spatial Extender
IBM Silicon Valley Lab