- Å©¸²½¼¿¡µðÅÍ ÇÑ±Û °Ô½ÃÆÇÀÔ´Ï´Ù. ¿¡µðÅÍ¿Í °ü·ÃÇÑ ¹ö±×, Á¦¾È ¶Ç´Â ÀÇ°ßÀ» Àû¾îÁÖ¼¼¿ä.
|
2004/11/12 (15:14)
|
Article Number : 6495
|
À±ÀÏÁø
|
Access : 5842
,
Lines : 49
|
auto indent ¹× ¸î°¡Áö °ÇÀÇ »çÇ×
|
---|
¸ÕÀú Å©¸²½¼ ¿¡µðÅÍ¿Í °°Àº À¯¿ëÇÑ ÇÁ·Î±×·¥À» »ç¿ëÇÒ ¼ö ÀÖµµ·Ï ÇØÁֽŰͿ¡ ´ëÇØ °¨»çµå¸³´Ï´Ù.
¿°Ä¡ºÒ±¸ÇÏ°í auto indent °ü·ÃÇؼ ÇÑ°¡Áö °ÇÀǵ帳´Ï´Ù. ¿¹Àü¿¡µµ °ÇÀÇÇÑ ³»¿ëÀε¥ ¹Ý¿µÀÌ ¾ÈµÇ¾î¼¿ä.
ÇöÀç »ç¿ëÁß ºÒÆíÇÑÁ¡Àº ¹®¼ ³»¿ë°ú Ä¿¼À§Ä¡°¡ ¾Æ·¡¿Í °°À» ¶§ Ä¿¼ À§Ä¡¿¡¼ ¿£Å͸¦ ÀÔ·ÂÇÏ¸é ´ÙÀ½°ú °°ÀÌ µË´Ï´Ù.(| : Ä¿¼ À§Ä¡)
¿£ÅÍÀÔ·ÂÀüȸé
-----------------------------------------
select count(*) into v_cnt
from member
where mem_id = :v_mem_id;
| if v_cnt > 0 then
select ...
from ....
where ...;
end if;
-----------------------------------------
¿£ÅÍÀÔ·ÂÈÄ È¸é
------------------------------------------
select count(*) into v_cnt
from member
where mem_id = :v_mem_id;
| if v_cnt > 0 then
select ...
from ....
where ...;
end if;
-----------------------------------------
±â´ë½ÃµÇ´Â ȸé(ultraedit ¿¡¼´Â ¾Æ·¡¿Í °°ÀÌ ³ª¿É´Ï´Ù.)
------------------------------------------
select count(*) into v_cnt
from member
where mem_id = :v_mem_id;
| if v_cnt > 0 then
select ...
from ....
where ...;
end if;
-----------------------------------------
alt+K ¸¦ ÀÌ¿ëÇÏ¸é ¿øÇÏ´Â °á°ú¸¦ ¾òÀ» ¼ö´Â ÀÖÁö¸¸ ¼Õ¿¡ Àͼ÷ÇÏÁöµµ ¾Ê°í À߸ø ´©¸£´Â °æ¿ì alt Å° ¶§¹®¿¡ Ä¿¼°¡ ¸Þ´º·Î °¡¹ö¸³´Ï´Ù. ¤Ì¤Ì;;;
±×¸®°í ´ÜÃàÅ°¸¦ »ç¿ëÀÚ ÀÓÀÇ·Î º¯°æÇÒ ¼ö ÀÖ´Â ±â´ÉÀº Á¦°øÇÏ½Ç »ý°¢ÀÌ ¾øÀ¸½ÅÁö¿ä?
±×·³ ¼ö°íÇϼ¼¿ä.
|
|
|
|
|