シェルã§ã‚ªãƒ©ã‚¯ãƒ«(Oracle)ã«å¼•æ•°ã‚’渡ã—ã€å®Ÿè¡Œå¾Œãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è²°ã†<IT技術ã®å‡¦æ–¹ç®‹ï¼šã‚·ã‚§ãƒ«ã§ã‚ªãƒ©ã‚¯ãƒ«(Oracle)ã«å¼•æ•°ã‚’渡ã—ã€å®Ÿè¡Œå¾Œãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è²°ã†> シェルã§Oracleã«å¼•æ•°ã‚’渡ã—ã¦å®Ÿè¡Œã—ã¦å®Ÿè¡Œã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ æµã‚Œã¨ã—ã¦ã¯ã€ã‚·ã‚§ãƒ«â†’SQLスクリプト→（プãƒã‚·ãƒ¼ã‚¸ãƒ£ãªã©ï¼‰ã¨ãªã‚Šã¾ã™ã€‚ 以下ã®ä¾‹ã§ã¯ã€aa.shã‚’å©ãã¨ã€ aa.sh →　aa.sql →　AAA_PROCEDUREã¨ã„ã†é †ç•ªã§å®Ÿè¡Œã•ã‚Œã¦ã€ ステータスãŒè¿”å´ã•ã‚Œã¾ã™ã€‚ â—シェル(aa.sh) #!/bin/bash MSG=`sqlplus user/pass@SID @aa.sql $1 $2` echo $MSG â—SQLスクリプト(aa.sql) set feed off; set head off; set serverout on; exec AAA_PROCEDURE('$1','$2'); exit; $1ã¨$2ã¯å¼•æ•°ã§ã™ã€‚ @aa.sqlã¯çµ¶å¯¾ãƒ‘スã®æŒ‡
SQL*Loader制御ファイル・リファレンス
SQL*Loaderメモ(Hishidama's sqlloader for Oracle9i Memo)
syboos.jp
ＯＲＡＣＬＥï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆROWNUM）
order byã—ãŸå¾Œã«rownumã‚’ä»˜åŠ ã™ã‚‹ | Oracle | æ ªå¼ä¼šç¤¾CONFRAGE
SQLã§æ¤œç´¢çµæžœã®å‡ºåŠ›ä»¶æ•°æŒ‡å®šï¼Ÿ
ROWNUMよりROW_NUMBER() - A Day In The Life
OTN Japan - æ„外ã¨ç°¡å˜!? Oracle Database 10g：Linux版 第1ç« 
Oracle Database Liteã§ã®SQLã®åˆ¶é™äº‹é …
『[Oracle] JDBCã§ãƒã‚¤ãƒ³ãƒ‰ã§ãã‚‹æ–‡å—列ã®ã‚µã‚¤ã‚ºã®åˆ¶é™ã€![『[Oracle] JDBCã§ãƒã‚¤ãƒ³ãƒ‰ã§ãã‚‹æ–‡å—列ã®ã‚µã‚¤ã‚ºã®åˆ¶é™ã€](https://cdn-ak-scissors.b.st-hatena.com/image/square/ed239427f781d723ae5cf65616a522073f68d378/height=288;version=1;width=512/https%3A%2F%2Fstat.profile.ameba.jp%2Fprofile_images%2F31%2Farchive-redo-blog%2F1180840362506.jpg)
NetBeans Wiki: VwpFAQOracleSqlDateJa
NetBeans Wiki: VwpFAQOracleExceptionJa
[Java] Oracle JDBC Driver 10g ã®ç½ ![[Java] Oracle JDBC Driver 10g ã®ç½](https://cdn-ak-scissors.b.st-hatena.com/image/square/06a15c64ba0ceec233d86d71001ebb29a9dcbf5d/height=288;version=1;width=512/https%3A%2F%2Fcdn.blog.st-hatena.com%2Fimages%2Ftheme%2Fog-image-1500.png)
{{#tags}}- {{label}}
{{/tags}}