Re: cool 9i feature - order SIBLINGS by ... and sys_connect_by_path

I should have started that last post with the comment:

    Thanks very much for the information,     please keep them coming.

One of my gripes about Oracle is that many of the most useful changes are little things that are never glamorous enough to make it to the press releases or 'new features' summaries.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Jonathan Lewis wrote in message
<994786401.8669.0.nnrp-07.9e984b29_at_news.demon.co.uk>...


>

>Of course, one shouldn't really mention

>undocumented features, but the

>    sys_connect_by_path( ename, '/' )

>syntax is also valid in 8.1.7, provided

>you have set

>    _new_connect_by_enabled = true.

>

>(Now I just have to figure out the

>other 23 SYS_xxxx functions :)

>

>

>--

>Jonathan Lewis

>

>

>Thomas Kyte wrote in message <9if64v0brg_at_drn.newsguy.com>...

>>In article <9if58008jt_at_drn.newsguy.com>, Thomas says...

>>>

>>

>>

>>scott_at_TKYTE901.US.ORACLE.COM> select lpad('*', level, '*' ) || ename

 ename,


>>  2         sys_connect_by_path( ename, '/' ) path

>>  3  from emp

>>  4  start with mgr is null

>>  5  connect by prior empno = mgr

>>  6  order SIBLINGS by ename DESC

>>  7  /

>>