- Äɲ䵤줿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
- ºï½ü¤µ¤ì¤¿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
// ²¼³¬ÁØÍѥƥó¥×¥ì¡¼¥È
#topicpath
----
//¤³¤³¤Ë¥³¥ó¥Æ¥ó¥Ä¤òµ½Ò¤·¤Þ¤¹¡£
Oracle¤Ï¤Û¤È¤ó¤ÉÃΤé¤Ê¤¤¤Î¤Ç¡¢¤È¤ê¤¢¤¨¤ºÈ÷˺¡£
**SQL*Plus¤ÎTIPS [#e895e9d8]
***³°Éô¥Õ¥¡¥¤¥ë¤«¤éSQL¼Â¹Ô [#g41782bf]
sqlplus user/pass @hogehoge.sql
¤Çhogehoge.sql¤ÎSQL¤¬¼Â¹Ô¤Ç¤¤ë
***hogehoge.sql¤Îʸˡ [#jef18876]
-SQL*Plus¤Ï¤É¤¦¤â°ì¥«¥é¥à¤¢¤¿¤ê¤ÎÉý¤¬¶¹¤¯¡¢¤¹¤°¤ËÀÞ¤êÊÖ¤·¤Á¤ã¤¦¡£
set linesize 9999
¤Ç²£¤Ë¤É¡¼¤ó¤È¹¤¤É½¼¨¤Ë¤Ê¤ë¡£¡£
-SQL*Plus¤Ï¤¹¤°¤Ë¥Ø¥Ã¥À(¥«¥é¥à̾)¤òÁÞÆþ¤·¤Á¤ã¤¦¡£
set pagesize 10000
¤È¤«¤Ç¥Ø¥Ã¥À¤òÁÞÆþ¤·¤Ê¤¤¤è¤¦¤Ë¤¹¤ë
-¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹ÊýË¡¡£¤É¤¦¤âhogehoge.sql¤Ç
spool result.txt
SQLʸ¡£
spool off
exit
¤È¤¹¤ë¤È½ÐÎÏ·ë²Ì¤ò¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹¤ß¤¿¤¤¡£
***SQL*Plus¤ÈTeraTerm¤Çüâ¤Ê¤É¤¬Ê¸»ú²½¤±¤¹¤ë [#mb64a834]
DB¤Îʸ»ú¥³¡¼¥É¤òJA16SJISTILDE¤È¤·¤Æ¤¤¤ë¤È¤¡¢TerraTerm¤Çselect¤·¤Æ¤ß¤ë¤Èü⤬ʸ»ú²½¤±¤·¤Æ¤¿¡£¡£
export NLS_LANG=Japanese_Japan.JA16SJISTILDE
¤È¤·¤Æ´Ä¶ÊÑ¿ô¤òÀßÄꤷ¡¢¤µ¤é¤ËTeraTerm¤òSJIS¤Ë¤·¤Æ¤ª¤±¤ÐOK¤Ç¤¹¡£
----
¤³¤Îµ»ö¤Ï
#vote(¤ª¤â¤·¤í¤«¤Ã¤¿,¤½¤¦¤Ç¤â¤Ê¤¤)
#comment
#topicpath
SIZE(10){¸½ºß¤Î¥¢¥¯¥»¥¹:&counter;}