DB/SQL/ÊÑ¿ô¤ÎÍøÍÑ
ÊÑ¿ô¤òÍøÍѤ¹¤ë†
ÊÑ¿ô¤òÍøÍѤ¹¤ë¡£¤¢¤ë¤¤¤Ï¥æ¡¼¥¶¤«¤é¤ÎÆþÎϤòÊÑ¿ô¤È¤·¤Æ°·¤¦¡£
- ¤¿¤À¤ÎÊÑ¿ô¤È¤·¤Æ»È¤¦
-- ÄêµÁ¤¹¤ë define foo = 100 -- »È¤¦ select hoge from piyo where fuga = &foo -- ÄêµÁ¤òºï½ü¤¹¤ë undefine foo
- ¥æ¡¼¥¶¤ÎÆþÎϤò¼õ¤±ÉÕ¤±¤ë
-- °ìÅÙ¤·¤«»È¤ï¤Ê¤¤¤È¤ select hoge from piyo where fuga = '&user_input' -- Ʊ¤¸Ãͤò²¿ÅÙ¤«»È¤¦¤È¤ select &&user_input from piyo order by &user_input
- ¥æ¡¼¥¶¤ËÆþÎϤ¬µá¤á¤é¤ì¤ë¤Î¤Ï¡¢¤½¤ÎÊÑ¿ô¤¬Ì¤ÄêµÁ¤Ç¤¢¤ë¤È¤¡£define ʸ¤Ê¤É¤ÇÄêµÁºÑ¤ß¤Ç¤¢¤ì¤Ð¤½¤ÎÃͤÇÃÖ´¹¤µ¤ì¡¢¥æ¡¼¥¶¤ËÆþÎϤ¬µá¤á¤é¤ì¤ë¤³¤È¤Ï¤Ê¤¤¡£
- ÊÑ¿ô¤ÎÃÖ´¹¤ÎÍͻҤòɽ¼¨¤µ¤»¤ë
-- ÊÑ¿ôÃÖ´¹¤Îɽ¼¨¤ò͸ú¤Ë¤¹¤ë set verify on -- ÊÑ¿ôÃÖ´¹¤Îɽ¼¨¤ò̵¸ú¤Ë¤¹¤ë set verify off
Last-modified: 2011-10-17 (·î) 20:04:58