> With HORA, it is no problem to display the hierarchic structure via the
> CONNECT BY clause. I tried the same statement in PHP3 and it
I'm using php4pl1 with Oracle 8.1.6 and this works:
select c.cvsn_id,
c.parent_cvsn_id,
level
from cvsn c
where start with c.cvsn_id = :cvsn_id
connect by prior c.cvsn_id = c.parent_cvsn_id
David
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]