Å©¸²½¼¿¡µðÅÍ ÀÚÀ¯ °Ô½ÃÆÇ

- Å©¸²½¼¿¡µðÅÍ ÇÑ±Û °Ô½ÃÆÇÀÔ´Ï´Ù. ¿¡µðÅÍ¿Í °ü·ÃÇÑ ¹ö±×, Á¦¾È ¶Ç´Â ÀÇ°ßÀ» Àû¾îÁÖ¼¼¿ä.

2003/05/20 (13:55) Article Number : 670
Delete Modify À±ÀÏÁø 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;
-----------------------------------------

Á¦°¡ À߸ø¾Ë°í À־ À̺κÐÀ» Á¦´ë·Î »ç¿ëÇÒ ¼ö ÀÖ´Â ±â´ÉÀÌ ÀÖ´Ù¸é °¡¸£ÃÄ ÁÖ½Ã°í ¾Æ´Ï¸é ´ÙÀ½ ¹öÀü¿¡¼­ ¼öÁ¤ÇØÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.

±×·³ Áñ°Å¿î ½Ã°£µÇ½Ã°í ¼ö°íÇϼ¼¿ä.

Backward Forward Post Reply List