- Å©¸²½¼¿¡µðÅÍ ÇÑ±Û °Ô½ÃÆÇÀÔ´Ï´Ù. ¿¡µðÅÍ¿Í °ü·ÃÇÑ ¹ö±×, Á¦¾È ¶Ç´Â ÀÇ°ßÀ» Àû¾îÁÖ¼¼¿ä.
|
2003/05/20 (13:55)
|
Article Number : 670
|
À±ÀÏÁø
|
Access : 4352
,
Lines : 47
|
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;
-----------------------------------------
Á¦°¡ À߸ø¾Ë°í ÀÖ¾î¼ À̺κÐÀ» Á¦´ë·Î »ç¿ëÇÒ ¼ö ÀÖ´Â ±â´ÉÀÌ ÀÖ´Ù¸é °¡¸£ÃÄ ÁÖ½Ã°í ¾Æ´Ï¸é ´ÙÀ½ ¹öÀü¿¡¼ ¼öÁ¤ÇØÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.
±×·³ Áñ°Å¿î ½Ã°£µÇ½Ã°í ¼ö°íÇϼ¼¿ä.
|
|
|
|
|