Image | Audio | Video |
---|---|---|
X | X | X |
À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À Å©±â(¹ÙÀÌÆ® ´ÜÀ§)¸¦ ¸®ÅÏÇÕ´Ï´Ù.
Include ÆÄÀÏ
±¸¹®
>>-Size--(--handle--)------------------------------------------><
¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)
¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)
À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿ÀÀÇ ¹ÙÀÌÆ® Å©±â(INTEGER).
¿¹
employee Å×À̺íÀÇ picture Ä÷³¿¡¼ 310 KB ÀÌ»ó Å©±âÀÇ À̹ÌÁö ¸ðµÎÀÇ ÆÄÀÏ À̸§À» È®º¸ÇϽʽÿÀ.
EXEC SQL BEGIN DECLARE SECTION; char hvImg_fname[251]; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT FILENAME(PICTURE) INTO :hvImg_fname FROM EMPLOYEE WHERE SIZE(PICTURE) > 310000;