1. °³¹ß/½ÇÇà Ç÷§Æû (1) OS : À©µµ¿ì 7 (2) °³¹ßÅø : µ¨ÆÄÀÌ 7 (3) »ç¿ë Database : Oracle 10g
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥ : ±¸¸Å³»¿ª Á¶È¸ ÇÁ·Î±×·¥
3. Áú¹® ³»¿ë
±âÁ¸¿¡ ADO ( ¿À¶óŬ Ŭ¶óÀ̾ðÆ® ÀÌ¿ë ) À¸·Î »ç¿ëÁßÀÎ ÇÁ·Î±×·¥À» UNIDAC º¯°æÀÛ¾÷ Áß¿¡ ÀÖ½À´Ï´Ù.
±×·±µ¥ TUniQuery ÀÌ¿ëÇÏ¿© Á¶È¸ÇÏ´Â Äõ¸®Áß¿¡ ¿¹½Ã )
select case gubun when ''A'' then ''Á¤»ó'' when ''B'' then ''Ãë¼Ò'' when ''C'' then ''¹ÝÇ°'' end as result_gubun from table_ex
À̶õ°É »ç¿ëÈÄ Á¶È¸½Ã ±âÁ¸¿¡ ado ÀÌ¿ë½Ã¿¡´Â ¹®Á¦°¡ ¾ø¾ùÀ¸³ª unidac ÀÌ¿ë½Ã¿¡´Â ¿¡·¯¸¦ ÅäÇس»¼ ¿øÀÎ ºÐ¼®Çغ¸´Ï Äõ¸® Áß°£¿¡ ÇѱÛÀÌ µé¾î°¡¼ »ý±â´Â ¹®Á¦ÀÎ°É È®ÀÎ ÇÏ¿´½À´Ï´Ù.
select case gubun when ''A'' then ''ok'' when ''B'' then ''cancel'' when ''C'' then ''void'' end as result_gubun from table_ex
ÀÌ·±½ÄÀ¸·Î¿ä Ȥ½Ã À§»çÇ×ÀÌ ¾î¶»°Ô »ý±â´Â ¹®Á¦ÀÎÁö À§¹æ¹ý¸»±¸ ´Ù¸¥¹æ¹ýÀ¸·Î ÇØ°á°¡´ÉÇÑÁö ¹®ÀÇ µå¸³´Ï´Ù.
µµ¿ÍÁÖ¼¼¿ä ¤Ì¤Ð
|