Hi DBA Guru's,



My requirement is to "display all trees (the entire tree) with JPM appearing
in any level of the tree: "

The below query is not giving correct result. Could any one help me to
complete this query.





SELECT lpad(' ',(level - 1) * 5) || customer_name as
padded_name,eci_id,spn_id,parent_eci_id,level as cust_level

FROM enterprise_customer

connect by prior eci_id = parent_eci_id start with eci_id in

(select eci_id from enterprise_customer where parent_eci_id is null and
upper(customer_name) like 'JPM%')









Thanks in advance.



Thanks,

Guru




Oracle LazyDBA home page