oracle procedure ʵ¼Ê¿ª·¢Óöµ½µÄÎÊÌâ

ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id  number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)


ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄname×Ö¶ÎÓÐÔÚµÚ¶þÕűídeletenameÖгöÏֵļǼ,
ÔõôдÐÔÄÜ×î¸ß°¡,´ó¼Ò¼¯Ë¼¹ãÒå°¡,СµÜÔÚ´Ëл¹ýÁË......

---

delete a
where exist
(
select 1
from b
where a.name=b.deletename

)

---

ÒýÓÃ

delete a
where exist
(
select 1
from b
where a.name=b.deletename

)

select 1 ÊÇʲôÒâ˼°¡

---

select 1
±íʾ³öÀ´µÄ½á¹ûÎÞËùνµÄ
Ö»ÓÐÆ¥ÅäÖµ¾Í·µ»Ø

---

Ö»ÊÇÏ°¹ßд·¨£¬ÆäʵÄã¿ÉÒÔдÈκÎÖµ£¬²»Ó°Ïì½á¹ûµÄ

---

1.
delete a
where exist
(
select 1
from b
where a.name=b.deletename

)
2.
delete a
where a.name in 
(
select b.deletename
from b
) 
ÕâÁ½¸ö,ÄĸöÐÔÄܸߵã

---

ÕâÖÖÊý¾ÝÁ¿EXISTÓ¦¸Ã»á¿ìµã

---

delete from a
where a.name in
(
select deletename
from a,b
where a.name=b.deletename
);

---

delete a
where exist
(
select 1
from b
where a.name=b.deletename

)
¿ìЩ

---

  ÔÚʵ¼ÊµÄÏîÄ¿Ó¦ÓÃÖÐÓ¦¸Ã¾¡Á¿±ÜÃâʹÓà in ºÍ no