ORACLE µÝ¹éɾ³ýÊý¾Ý

Êý¾Ý¿âÉè¼Æ£º
CREATE  TABLE  ADVERTISE_CATEGORY
(
       CATEGORY_ID       NUMBER PRIMARY KEY,  --½ÚµãID 
       CATEGORY_NAME     VARCHAR2(500),       --½ÚµãÃû×Ö 
       PARENT_ID         NUMBER                          --¸¸½ÚµãID
)
±íÊý¾Ý
ɾ³ý ½ÚµãIDΪ1µÄ´æ´¢¹ý³Ì
create or replace procedure sp_advertise_category_del
(
       v_cate_id  in number
)
 is
 begin
       delete from advertise_category where category_id in
        (select category_id from advertise_category  start with category_id=v_cate_id connect by prior category_id = parent_id);
 end;