Oracle¤Ï¤Û¤È¤ó¤ÉÃΤé¤Ê¤¤¤Î¤Ç¡¢¤È¤ê¤¢¤¨¤ºÈ÷˺¡£
sqlplus user/pass @hogehoge.sql
¤Çhogehoge.sql¤ÎSQL¤¬¼Â¹Ô¤Ç¤¤ë
set linesize 9999¤Ç²£¤Ë¤É¡¼¤ó¤È¹¤¤É½¼¨¤Ë¤Ê¤ë¡£¡£
set pagesize 10000¤È¤«¤Ç¥Ø¥Ã¥À¤òÁÞÆþ¤·¤Ê¤¤¤è¤¦¤Ë¤¹¤ë
spool result.txt SQLʸ¡£ spool off exit¤È¤¹¤ë¤È½ÐÎÏ·ë²Ì¤ò¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹¤ß¤¿¤¤¡£
DB¤Îʸ»ú¥³¡¼¥É¤òJA16SJISTILDE¤È¤·¤Æ¤¤¤ë¤È¤¡¢TerraTerm?¤Çselect¤·¤Æ¤ß¤ë¤Èü⤬ʸ»ú²½¤±¤·¤Æ¤¿¡£¡£
export NLS_LANG=Japanese_Japan.JA16SJISTILDE
¤È¤·¤Æ´Ä¶ÊÑ¿ô¤òÀßÄꤷ¡¢¤µ¤é¤ËTeraTerm?¤òSJIS¤Ë¤·¤Æ¤ª¤±¤ÐOK¤Ç¤¹¡£
¤³¤Îµ»ö¤Ï
¸½ºß¤Î¥¢¥¯¥»¥¹:39470