| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deleting children, grandchildren, etc.
Have you tried something similar to the following: -
delete from my_table
where company_id in (
select company_id
from my_table
start with company_id = xyz
connect by company_id = prior parent_company_id
);
--
David Lord
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 04 2006 - 14:20:27 CDT
 |
 |