DB/Oracle/PLSQL/³µÍפȴðËÜ
Ìܼ¡†
PL/SQL ¤Ë¤Ä¤¤¤Æ¤Î¤Þ¤È¤á¡£Pukiwiki ¤ÎÀ©ÌóÅÔ¹ç¾å¡¢¥Ú¡¼¥¸Ì¾¤¬ PLSQL ¤À¤±¤É¡¢Àµ¼°Ì¾¾Î¤Ï PL/SQL ¤Ê¤Î¤Çµ¤¤ò¤Ä¤±¤ë¡Ê¤Ü¤¯¤¬¡Ë¡£
PL/SQL ¤È¤Ï†
- SQL ¤ò³ÈÄ¥¤·¤¿¸À¸ì¡£SQL ¤Ï¤â¤È¤â¤ÈÈó¼ê³¤·¿¸À¸ì¤Ç¡¢¤½¤ì¤ò¼ê³¤·¿¸À¸ì¤Ë³ÈÄ¥¤·¤¿¤â¤Î
¼Â¹Ô»þ¤ÎµóÆ°†
- PL/SQL ¥¨¥ó¥¸¥ó¤Ç³Æ¥Ö¥í¥Ã¥¯¤¬²òÀϤµ¤ì¤ë
- ¥Ö¥í¥Ã¥¯¤Î¤¦¤Á¤Î¥×¥í¥·¡¼¥¸¥ãʸ¤Ï¥×¥í¥·¡¼¥¸¥ãʸ¥¨¥°¥¼¥¥å¡¼¥¿¡¢SQL ʸ¤Ï SQL ʸ¥¨¥°¥¼¥¥å¡¼¥¿¤ËÆþ¤ë
- PL/SQL ¥¨¥ó¥¸¥ó¤Ï¥¯¥é¥¤¥¢¥ó¥È¦¤Ë¤¢¤Ã¤Æ¤â¥µ¡¼¥Ð¦¤Ë¤¢¤Ã¤Æ¤â¤¤¤¤¡£´ðËÜŪ¤Ë¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤Î¤ò»È¤¦
- Oracle Forms¡¢Oracle Reports ¤ä¤é¤Ê¤Ë¤ä¤é¤Î¥Ä¡¼¥ë¤À¤È¥¯¥é¥¤¥¢¥ó¥È¦¤ËÆþ¤ë
꿁ˠ
- SQL ¤È¥×¥í¥·¡¼¥¸¥ã¹½Â¤¡Ê¤¤¤ï¤æ¤ë¥×¥í¥°¥é¥ß¥ó¥°¸À¸ì¤Ã¤Ý¤¤´¶¤¸¤Î¥¢¥ì¡Ë¤ò°ì½ï¤Ë°·¤¨¤ë
- Ä̾ï¤Ï SQL ʸ¤Ò¤È¤Ä¤Ç¤Ò¤È¤Ä¤ÎÄÌ¿®¡¢¥µ¡¼¥Ð¦¤Î¥³¡¼¥ë¤À¤±¤É¡¢PL/SQL ¤ò»È¤¦¤È¥Ö¥í¥Ã¥¯Ã±°Ì¤Ç¤Þ¤È¤á¤ÆÁ÷¿®¤Ç¤¤ë¤Î¤ÇÄÌ¿®²ó¿ô¤¬¸º¤é¤»¤ë¡£½èÍý¸úΨ¤¬¾å¤¬¤Ã¤Æ¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤¬²þÁ±
- ¥×¥í¥°¥é¥à¤Î¥â¥¸¥å¡¼¥ë²½¡£¥Ö¥í¥Ã¥¯¤òÉôÉʤȤ·¤ÆºÆÍøÍѤǤ¤ë¤·¥Í¥¹¥È¤â¤Ç¤¤ë¤Î¤Ç¤ä¤ê¤¿¤¤ÊüÂê
- ¤¤¤í¤¤¤í¤Ê Oracle ¥Ä¡¼¥ë¤Ç»È¤ï¤ì¤Æ¤¤¤ë
- °Ü¹Ô¤¬³Ú¡£¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Ë°Í¸¤·¤Ê¤¤
- Îã³°½èÍý¤¬¤ï¤«¤ê¤ä¤¹¤¤¡£°ìÈֺǸå¤Ë¤Þ¤È¤á¤Æ½ñ¤¯¤Î¤Ç³Ú
¥Ö¥í¥Ã¥¯†
- ¥×¥í¥°¥é¥à¤ò°·¤¦Ã±°Ì¡£¤Ò¤È¤Ä¤Î¥Ö¥í¥Ã¥¯¤¬¤Ò¤È¤Ä¤Î¥×¥í¥°¥é¥à¤Ê¤«¤ó¤¸
- °Ê¹ß¡¢Âçʸ»ú¤È¾®Ê¸»ú¤Î¶èÊ̤Ϥʤ¤
¹½Â¤†
- DECLARE
- ¤Ò¤È¤Ä¤á¤Î¥»¥¯¥·¥ç¥ó¡£Àë¸ÀÉô¡£ÊÑ¿ôÀë¸À¤È¤«¥«¡¼¥½¥ëÀë¸À¤È¤«
- BEGIN
- ¤Õ¤¿¤Ä¤á¤Î¥»¥¯¥·¥ç¥ó¡£¼Â¹ÔÉô¡£¥á¥¤¥ó¤Î¥×¥í¥°¥é¥àÉôʬ¡£É¬¿Ü
- EXCEPTION
- ¤ß¤Ã¤Ä¤á¤Î¥»¥¯¥·¥ç¥ó¡£Îã³°½èÍýÉô¡£¥¨¥é¡¼½èÍý¤ò½ñ¤¯¤È¤³¤í
- END;
- ¥Ö¥í¥Ã¥¯¤Î½ªÎ»¡£¥»¥ß¥³¥í¥óÂç»ö¡£É¬¿Ü
¼ïÎà†
- ̵̾
- ¥µ¥Ö¥×¥í¥°¥é¥à
- ¥×¥í¥·¡¼¥¸¥ã
- ¥Õ¥¡¥ó¥¯¥·¥ç¥ó
- ¥Ñ¥Ã¥±¡¼¥¸
- ¥È¥ê¥¬
̵̾†
- ̾Á°¤òÉÕ¤±¤Ê¤¤¡£ºÆÍøÍѤ·¤Ê¤¤Á°Äó¡¢°ì²ó¤·¤«»È¤ï¤Ê¤¤¤È¤¤Ê¤É¤Ë
¥µ¥Ö¥×¥í¥°¥é¥à†
- ̾Á°¤òÉÕ¤±¤ÆÊݸ¤·¤Æ¤ª¤¯¤â¤Î¡£Ì¾Á°¤¬¤¢¤ë¤Î¤Ç¸Æ¤Ó½Ð¤»¤ë¡£²¿²ó¤â»È¤¦¤È¤¤Ê¤É¤Ë
- ¥µ¡¼¥Ð¦¤ËÊݸ¤·¤Æ¤ª¤¯¤â¤Î¤ò¥¹¥È¥¢¥É¤Û¤²¤Û¤²¡¢¥¯¥é¥¤¥¢¥ó¥È¦¤ËÊݸ¤·¤Æ¤ª¤¯¤â¤Î¤ò¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤Û¤²¤Û¤²¤È¸Æ¤Ö
- ¥¹¥È¥¢¥É¥×¥í¥·¡¼¥¸¥ã¡¢¥¹¥È¥¢¥É¥Õ¥¡¥ó¥¯¥·¥ç¥ó¤È¤«
´ðËܹ½Ê¸¤Î¥µ¥ó¥×¥ë†
¤¹¤ó¤´¤¤´Êñ¤ÊÎã¡£²èÌ̽ÐÎϤϥǥХå°ÌÜŪ¤Ç¤è¤¯»È¤¦¡£
END; ¤Þ¤Ç¤Ç¥Ð¥Ã¥Õ¥¡¤Ë³ÊǼ¡¢/ ¤Ç¥Ð¥Ã¥Õ¥¡¤ÎÆâÍƤμ¹ԡ¢¤Ã¤Æ¤¤¤¦¥¤¥á¡¼¥¸¡£¤¿¤Ö¤ó¡£
̵̾¥Ö¥í¥Ã¥¯¤ÎÎã†
- @hoge.sql
declare hoge number; begin hoge := 10; -- ²¿¤â¤·¤Ê¤¤½èÍý¤Ï null ¤Ç¤¢¤é¤ï¤¹ null; end; /
²èÌ̤Ëʸ»ú¤ò½ÐÎϤ¹¤ë†
- @fuga.sql
begin dbms_output.put_line('hoge'); end; /
- SQL*Plus ¤Ç½ÐÎϤò͸ú¤Ë¤¹¤ë¾ì¹ç¤Ï set serveroutput on ¤·¤Æ¤ª¤¯É¬Íפ¬¤¢¤ë
Last-modified: 2011-11-08 (²Ð) 11:53:19