DB/Oracle/PLSQL/¥×¥í¥·¡¼¥¸¥ã¤È¥Õ¥¡¥ó¥¯¥·¥ç¥ó

Top/DB/Oracle/PLSQL/¥×¥í¥·¡¼¥¸¥ã¤È¥Õ¥¡¥ó¥¯¥·¥ç¥ó

Ìܼ¡

»È¤¤¼Î¤Æ¤Î̵̾¤Ê¤Î¤¸¤ã¤Ê¤¯¤Æ¡¢Ì¾Á°¤òÉÕ¤±¤ÆÊݸ¤·¤Æ¤ª¤¯¥×¥í¥·¡¼¥¸¥ã¤â¤·¤¯¤Ï¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤Î¤ªÏᣥµ¥Ö¥×¥í¥°¥é¥à¡£


¥×¥í¥·¡¼¥¸¥ã¤È¥Õ¥¡¥ó¥¯¥·¥ç¥ó

̾Á°¤òÉÕ¤±¤ÆÊݸ¤·¤Æ¤ª¤¯¥µ¥Ö¥×¥í¥°¥é¥à¤Î¤³¤È¡£Êݸ¾ì½ê¤Ï¥í¡¼¥«¥ë¤À¤Ã¤¿¤ê¥µ¡¼¥Ð¤À¤Ã¤¿¤ê¤¹¤ë¡£Ì¾Á°¤òÉÕ¤±¤ÆÊݸ¤·¤Æ¤¢¤ë¤Î¤Ç¡¢Ì¾Á°¤ò»ØÄꤷ¤Æ¤Û¤«¤Î¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤«¤é¥³¡¼¥ë¡Ê¼Â¹Ô¡Ë¤Ç¤­¤ë¡£

ÃͤòÊÖ¤µ¤Ê¤¤¤Î¤¬¥×¥í¥·¡¼¥¸¥ã¤Ç¡¢ÃͤòÊÖ¤¹¤Î¤¬¥Õ¥¡¥ó¥¯¥·¥ç¥ó¡£¥×¥í¥·¡¼¥¸¥ã¤ÎÃæ¤«¤é¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤ò¸Æ¤Ó½Ð¤¹¡¢¤È¤¤¤¦·Á¤¬Â¿¤¤¡£¤Î¤«¤Ê¤¢¡£

¥×¥í¥·¡¼¥¸¥ã

´ðËܤι½Ê¸

¤À¤¤¤¿¤¤ÌµÌ¾¥Ö¥í¥Ã¥¯¤È°ì½ï¡£

  • ¥¹¥È¥¢¥É¥×¥í¥·¡¼¥¸¥ã¤Î¹½Ê¸
  • ¥Ñ¥é¥á¡¼¥¿¤Î¥â¡¼¥É
    ¥â¡¼¥ÉÀâÌÀ
    in¸Æ¤Ó½Ð¤·¸µ¤«¤é¼õ¤±¼è¤ë¥Ñ¥é¥á¡¼¥¿¡£¥â¡¼¥É¤ò¾Êά¤¹¤ë¤È¤³¤ì¤Ë¤Ê¤ë
    out¸Æ¤Ó½Ð¤·¸µ¤ËÊÖ¤¹¥Ñ¥é¥á¡¼¥¿
    in out¸Æ¤Ó½Ð¤·¸µ¤«¤é¼õ¤±¼è¤Ã¤ÆÊÖ¤¹¥Ñ¥é¥á¡¼¥¿

¼Â¹ÔÊýË¡

¾¤Î̵̾¥Ö¥í¥Ã¥¯¤ä¥×¥í¥·¡¼¥¸¥ã¤«¤é¼Â¹Ô¤¹¤ë¾ì¹ç¤Ï¡¢¥×¥í¥·¡¼¥¸¥ã̾¤òñ¤Ëµ­½Ò¤¹¤ë¤À¤±¡£

  • HOGE ¥×¥í¥·¡¼¥¸¥ã¤ò¾¤Î¥µ¥Ö¥×¥í¥°¥é¥à¤ä̵̾¥Ö¥í¥Ã¥¯¤«¤é¸Æ¤Ó½Ð¤¹

SQL*Plus ¤«¤éľÀÜÆ°¤«¤¹¾ì¹ç¤Ï EXECUTE ʸ¤òÍѤ¤¤ë¡£°ú¿ô¤Î»ØÄêÊýË¡¤Ï¾å¤È°ì½ï¡£

  • HOGE ¥×¥í¥·¡¼¥¸¥ã¤ò SQL*Plus ¤«¤é¸Æ¤Ó½Ð¤¹

¥Õ¥¡¥ó¥¯¥·¥ç¥ó

¤¤¤ï¤æ¤ë´Ø¿ô¡£¹Í¤¨Êý¤Ï¾¸À¸ì¤ÈƱ¤¸¡£ÃͤòÂåÆþ¤¹¤ë¤¿¤á¤À¤Ã¤¿¤ê¡¢¾ò·ïȽÄê¤Ë»ÈÍѤ·¤¿¤ê¡¢¥Õ¥£¥ë¥¿¤Ë»ÈÍѤ·¤¿¤ê¡¢¤¤¤í¤¤¤í¤ÊÌÜŪ¤Ë»È¤¨¤ë¡£

´ðËܤι½Ê¸

¥×¥í¥·¡¼¥¸¥ã¤È¤Û¤È¤ó¤É°ì½ï¡£PROCEDURE ¤¬ FUNCTION ¤Ë¤Ê¤Ã¤¿¤Î¤È¡¢ÊÖ¤êÃͤΤ¿¤á¤Î RETURN ¤¬Áý¤¨¤¿ÅÀ¤À¤±¤¬°ã¤¦¡£

RETURN ¤ÇÊÖ¤»¤ë¥Ç¡¼¥¿¤Ï°ì¤Ä¤À¤±¡£

  • ¥¹¥È¥¢¥É¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤Î¹½Ê¸

¼Â¹ÔÊýË¡

  • HOGE ¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤ò¾¤Î¥µ¥Ö¥×¥í¥°¥é¥à¤ä̵̾¥Ö¥í¥Ã¥¯¤«¤é¸Æ¤Ó½Ð¤¹

SQL*Plus ¤«¤éľÀÜÆ°¤«¤¹¾ì¹ç¤Ã¤Æ¤¢¤ó¤Þ¤ê¤Ê¤¤¤È»×¤¦¤±¤É¡¢DUAL ɽ¤«¤é¤Ò¤¤¤Æ»È¤¦¤È¤«¤«¤Ê¤¢¡£

  • HOGE ¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤ò SQL*Plus ¤«¤é¸Æ¤Ó½Ð¤¹
    select hoge from dual;
    select hoge(10) from dual;
    

¥³¥ó¥Ñ¥¤¥ë¤È¥¨¥é¡¼¤Î¾ÜºÙ

CREATE PROCEDURE ¤·¤¿¤é¡Ø·Ù¹ð: ¥×¥í¥·¡¼¥¸¥ã¤¬ºîÀ®¤µ¤ì¤Þ¤·¤¿¤¬¡¢¥³¥ó¥Ñ¥¤¥ë¡¦¥¨¥é¡¼¤¬¤¢¤ê¤Þ¤¹¡£¡Ù¤Ã¤ÆÅܤé¤ì¤¿¡£¤Ç¤â¤É¤³¤¬¥¨¥é¡¼¤Ê¤ó¤À¤«²¿¤â¶µ¤¨¤Æ¤¯¤ì¤Ê¤¤¡Ä¡Ä ¤È¤¤¤¦Ê¢Î©¤¿¤·¤¤»öÂÖ¤ËÁø¶ø¤·¤¿¤È¤­¤Ï¤ª¤Þ¤¸¤Ê¤¤¤ò¾§¤¨¤ë¤È¹¬¤»¤Ë¤Ê¤ì¤ë¡£

ÆüËܸì¤Ï¤ª¤«¤·¤¤¤ó¤À¤±¤É¤Þ¤¢¡Ä¡Ä ¤Ê¤¤¤è¤ê¤Þ¤·¡Ä¡Ä¡©

  • SHOW ERROR

Last-modified: 2011-11-09 (¿å) 14:21:42