DB/Oracle/¥³¥Þ¥ó¥É/SQL*Plus
Ìܼ¡†
Oracle Database ¤ò°·¤¦¾å¤Ç·ç¤«¤»¤Ê¤¤ SQL*Plus ¤ÎÏá£
Àܳ¤¹¤ë†
SYSDBA ¤È¤·¤ÆÀܳ¤¹¤ë¡£
- SQL*Plus µ¯Æ°¸å¤ËÀܳ¤¹¤ë¾ì¹ç
-- nolog ¥ª¥×¥·¥ç¥ó¤Ç¥í¥°¥¤¥ó¤»¤º¤Ëµ¯Æ°¤¹¤ë sqlplus /nolog -- OS ǧ¾Ú¤Î¾ì¹ç¤Ï¥æ¡¼¥¶Ì¾¤Ê¤É¤ÏÉÔÍס¢as sysdba ¤Ç sys ¤È¤·¤ÆÀܳ¤Ç¤¤ë conn / as sysdba
- SQL*Plus µ¯Æ°»þ¤ËÀܳ¤¹¤ë¾ì¹ç
-- OS ǧ¾Ú¤Î¾ì¹ç¤Ï¥æ¡¼¥¶Ì¾¤Ê¤É¤ÏÉÔÍס¢as sysdba ¤Ç sys ¤È¤·¤ÆÀܳ¤Ç¤¤ë sqlplus / as sysdba
¥Ø¥ë¥×¤Î±ÜÍ÷†
¥³¥Þ¥ó¥É¤Î»È¤¤Êý¤¬¤ï¤«¤é¤Ê¤¯¤Ê¤Ã¤¿¤ê¡¢¤½¤â¤½¤â¥³¥Þ¥ó¥É²¿¤¬¤¢¤ë¤ó¤À¤Ã¤±¡¢¤Ê¾õÂ֤˴٤俤ꤷ¤¿¤È¤¤Ë¡£
-- ÆÃÄê¤Î¥³¥Þ¥ó¥É¤Î»È¤¤Êý¤òÄ´¤Ù¤ë ? <command> help <command> -- ¥³¥Þ¥ó¥É¤Î°ìÍ÷¤òɽ¼¨¤¹¤ë ? index help index
OS ¥³¥Þ¥ó¥É¤Î¼Â¹Ô†
SQL*Plus ¤Î¥×¥í¥ó¥×¥È¤«¤é OS ¤Î¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤¹¤ë¡£
-- ËÞÎã host <command> -- ¤¿¤È¤¨¤Ð¥«¥ì¥ó¥È¥Ç¥£¥ì¥¯¥È¥ê¤Î³Îǧ host pwd -- ¤¿¤È¤¨¤Ð¥«¥ì¥ó¥È¥Ç¥£¥ì¥¯¥È¥ê¤ÎÊѹ¹ host cd /home/hoge
³°Éô¥Õ¥¡¥¤¥ë¤ÎÁàºî†
SQL*Plus ¤«¤é³°Éô¥Õ¥¡¥¤¥ë¤òÆɤ߹þ¤ó¤À¤êÊÔ½¸¤·¤¿¤ê¤¹¤ë¡£
-- ³°Éô¥Õ¥¡¥¤¥ë¤ò¼Â¹Ô¤¹¤ë @hoge.sql -- ³°Éô¥Õ¥¡¥¤¥ë¤òÊÔ½¸¤¹¤ë edit hoge.sql
¥µ¡¼¥Á¥Ñ¥¹¤Ë¤Ä¤¤¤Æ†
³°Éô¥Õ¥¡¥¤¥ë¤ò»ØÄꤹ¤ë¤È¤¡¢¥Õ¥¡¥¤¥ë̾¤Î¤ß¡Ê¤â¤·¤¯¤ÏÁêÂХѥ¹¡Ë¤òµ½Ò¤·¤¿¾ì¹ç¤Ï¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï SQL*Plus ¤òµ¯Æ°¤·¤¿¥Ç¥£¥ì¥¯¥È¥ê¡Ê¥«¥ì¥ó¥È¥Ç¥£¥ì¥¯¥È¥ê¡Ë¤¬¸Æ¤Ð¤ì¤ë¡£¥Õ¥ë¥Ñ¥¹¤Î¾ì¹ç¤Ï¤½¤ì¤Ë½¾¤¦¡£
¥«¥ì¥ó¥È¥Ç¥£¥ì¥¯¥È¥ê¤Ï host pwd ¤Ê¤É¤·¤Æ³Îǧ²Äǽ¡£Êѹ¹¤ÏƱÍÍ¤Ë host cd /home/hoge ¤Ê¤É¡£
Windows ´Ä¶¤Ç¤â¹Í¤¨Êý¤ÏƱ¤¸¡£¥·¥ç¡¼¥È¥«¥Ã¥È¤Ë¡Øºî¶È¥Õ¥©¥ë¥À¡Ù¤ò»ØÄꤷ¤Æ¤ª¤¯¤È³Ú¡£
¥Ð¥Ã¥Õ¥¡¤ÎÁàºî†
SQL*Plus ¤¬ÆâÉôŪ¤ËÁ°²ó¼Â¹Ô¤·¤¿¥³¥Þ¥ó¥É¤ò³ÊǼ¤·¤Æ¤¤¤ë¥Ð¥Ã¥Õ¥¡¤ËÂФ¹¤ëÁàºî¡£
-- ¥Ð¥Ã¥Õ¥¡¤ÎÆâÍƤòºÆ¼Â¹Ô¤¹¤ë / -- ¥Ð¥Ã¥Õ¥¡¤ÎÆâÍƤòºÆÆþÎϤ¹¤ë run -- ¥Ð¥Ã¥Õ¥¡¤ÎÆâÍƤòÊÔ½¸¤¹¤ë edit -- ¥Ð¥Ã¥Õ¥¡¤ÎÆâÍƤò³°Éô¥Õ¥¡¥¤¥ë¤ËÊݸ¤¹¤ë save hoge.sql
Éý¤ÎÊѹ¹†
-- ¹ÔÁ´ÂΤÎÉý¤ò»ØÄꤹ¤ë set linesize <byte> -- ÆÃÄê¤ÎÎó¤ÎÉý¤ò»ØÄꤹ¤ë column <column-name> format a<byte>
²èÌÌ¥í¥°¤ÎÊݸ†
½ÐÎϤò¥Õ¥¡¥¤¥ë¤ËÊݸ¤¹¤ë¡£ÆþÎϤ·¤¿¥³¥Þ¥ó¥É¤«¤é·ë²Ì¡¢´Ö°ã¤¨¤¿¤È¤¤Î¥¨¥é¡¼¤Þ¤Ç¡¢Íפ¹¤ë¤Ë¥æ¡¼¥¶¤¬²èÌ̤Ǹ«¤¿Á´¤Æ¤¬¥Õ¥¡¥¤¥ë¤ËÅǤ«¤ì¤ë¡£²þ¹Ô¤ä¤é¤Ê¤Ë¤ä¤é¤â¤½¤Î¤Þ¤Þ¡£
-- Êݸ³«»Ï spool <outputfile.log> -- Äɵ¤ÇÊݸ³«»Ï spool <outputfile.log> app -- Êݸ½ªÎ» spool off
PL/SQL ¤«¤é¤Î²èÌ̽ÐÎϤÎ͸ú²½†
PL/SQL ¤Î dbms_output.put_line ¤ò»ÈÍѤ·¤¿¤È¤¤Ê¤É¤Ë»È¤ï¤ì¤ë½ÐÎϤò͸ú¤Ë¤¹¤ë¡£¤³¤ì¤ä¤é¤Ê¤¤¤È PL/SQL ¤«¤é²¿¤â¤Ç¤¤Ê¤¤¤è¡ª
-- ͸ú²½ set serveroutput on -- ̵¸ú²½ set serveroutput off
Last-modified: 2011-11-07 (·î) 12:12:23