RE: [PHP-DB] CONNECT BY & PHP problem
| From: | David Benson | Date: | Mon, 19 Feb 2001 15:50:04 +0000 |
| Subject: | RE: [PHP-DB] CONNECT BY & PHP problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6739@lists.php.net to get a copy of this message | ||
> 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