DB/Oracle/¥³¥Þ¥ó¥É/SQL*Plus
Ìܼ¡ †
Oracle Database ¤ò°·¤¦¾å¤Ç·ç¤«¤»¤Ê¤¤ SQL*Plus ¤ÎÏá£
Àܳ¤¹¤ë †
SYSDBA ¤È¤·¤ÆÀܳ¤¹¤ë¡£
- SQL*Plus µ¯Æ°¸å¤ËÀܳ¤¹¤ë¾ì¹ç
- SQL*Plus µ¯Æ°»þ¤ËÀܳ¤¹¤ë¾ì¹ç
¥Ø¥ë¥×¤Î±ÜÍ÷ †
¥³¥Þ¥ó¥É¤Î»È¤¤Êý¤¬¤ï¤«¤é¤Ê¤¯¤Ê¤Ã¤¿¤ê¡¢¤½¤â¤½¤â¥³¥Þ¥ó¥É²¿¤¬¤¢¤ë¤ó¤À¤Ã¤±¡¢¤Ê¾õÂ֤˴٤俤ꤷ¤¿¤È¤¤Ë¡£
OS ¥³¥Þ¥ó¥É¤Î¼Â¹Ô †
SQL*Plus ¤Î¥×¥í¥ó¥×¥È¤«¤é OS ¤Î¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤¹¤ë¡£
³°Éô¥Õ¥¡¥¤¥ë¤ÎÁàºî †
SQL*Plus ¤«¤é³°Éô¥Õ¥¡¥¤¥ë¤òÆÉ¤ß¹þ¤ó¤À¤êÊÔ½¸¤·¤¿¤ê¤¹¤ë¡£
¥µ¡¼¥Á¥Ñ¥¹¤Ë¤Ä¤¤¤Æ †
³°Éô¥Õ¥¡¥¤¥ë¤ò»ØÄꤹ¤ë¤È¤¡¢¥Õ¥¡¥¤¥ë̾¤Î¤ß¡Ê¤â¤·¤¯¤ÏÁêÂХѥ¹¡Ë¤òµ½Ò¤·¤¿¾ì¹ç¤Ï¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï SQL*Plus ¤òµ¯Æ°¤·¤¿¥Ç¥£¥ì¥¯¥È¥ê¡Ê¥«¥ì¥ó¥È¥Ç¥£¥ì¥¯¥È¥ê¡Ë¤¬¸Æ¤Ð¤ì¤ë¡£¥Õ¥ë¥Ñ¥¹¤Î¾ì¹ç¤Ï¤½¤ì¤Ë½¾¤¦¡£
¥«¥ì¥ó¥È¥Ç¥£¥ì¥¯¥È¥ê¤Ï host pwd ¤Ê¤É¤·¤Æ³Îǧ²Äǽ¡£Êѹ¹¤ÏƱÍÍ¤Ë host cd /home/hoge ¤Ê¤É¡£
Windows ´Ä¶¤Ç¤â¹Í¤¨Êý¤ÏƱ¤¸¡£¥·¥ç¡¼¥È¥«¥Ã¥È¤Ë¡Øºî¶È¥Õ¥©¥ë¥À¡Ù¤ò»ØÄꤷ¤Æ¤ª¤¯¤È³Ú¡£
¥Ð¥Ã¥Õ¥¡¤ÎÁàºî †
SQL*Plus ¤¬ÆâÉôŪ¤ËÁ°²ó¼Â¹Ô¤·¤¿¥³¥Þ¥ó¥É¤ò³ÊǼ¤·¤Æ¤¤¤ë¥Ð¥Ã¥Õ¥¡¤ËÂФ¹¤ëÁàºî¡£
Éý¤ÎÊѹ¹ †
²èÌÌ¥í¥°¤ÎÊݸ †
½ÐÎϤò¥Õ¥¡¥¤¥ë¤ËÊݸ¤¹¤ë¡£ÆþÎϤ·¤¿¥³¥Þ¥ó¥É¤«¤é·ë²Ì¡¢´Ö°ã¤¨¤¿¤È¤¤Î¥¨¥é¡¼¤Þ¤Ç¡¢Íפ¹¤ë¤Ë¥æ¡¼¥¶¤¬²èÌ̤Ǹ«¤¿Á´¤Æ¤¬¥Õ¥¡¥¤¥ë¤ËÅǤ«¤ì¤ë¡£²þ¹Ô¤ä¤é¤Ê¤Ë¤ä¤é¤â¤½¤Î¤Þ¤Þ¡£
PL/SQL ¤«¤é¤Î²èÌ̽ÐÎϤÎ͸ú²½ †
PL/SQL ¤Î dbms_output.put_line ¤ò»ÈÍѤ·¤¿¤È¤¤Ê¤É¤Ë»È¤ï¤ì¤ë½ÐÎϤò͸ú¤Ë¤¹¤ë¡£¤³¤ì¤ä¤é¤Ê¤¤¤È PL/SQL ¤«¤é²¿¤â¤Ç¤¤Ê¤¤¤è¡ª
Last-modified: 2011-11-07 (·î) 12:12:23