»ç¿ëÀÚ´Â Robert SmithÀÇ À̹ÌÁö¿Í À½¼º ·¹ÄÚµùÀÌ ¾ó¸¶³ª ÃÖ±Ù¿¡ Á÷¿ø Å×ÀÌºí¿¡ ÀúÀåµÇ¾ú´ÂÁö¿¡ ´ëÇÑ Á¤º¸¸¦ °Ë»öÇÕ´Ï´Ù.
»ç¿ëÀÚ ¼öÇà ÀÛ¾÷: »ç¿ëÀÚ´Â ´ÙÀ½ ¿¹½Ã¿¡ Ç¥½ÃµÈ SQL¹®À» Æ÷ÇÔÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Á¤º¸¸¦ È®º¸ÇÕ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; char[255] hvImg_Time; char[255] hvAud_Time; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT IMPORTTIME(PICTURE), /*when image was stored*/ IMPORTTIME(VOICE) /*when audio was stored*/ INTO :hvImg_Time, :hvAud_Time FROM EMPLOYEE WHERE NAME='Robert Smith'; |
°á°ú: PICTURE Ä÷³¿ë ImportTime UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender´Â À̹ÌÁö°¡ ÀúÀåµÈ ³¯Â¥¿Í ½Ã°£À» Æ÷ÇÔÇÏ´Â ½Ã°£¼ÒÀÎÀ» ¸®ÅÏÇÕ´Ï´Ù. VOICE Ä÷³¿ë ImportTime UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Audio Extender´Â À½¼º ·¹ÄÚµùÀÌ ÀúÀåµÈ ³¯Â¥¿Í ½Ã°£À» Æ÷ÇÔÇÏ´Â ½Ã°£¼ÒÀÎÀ» ¸®ÅÏÇÕ´Ï´Ù.