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