[B! oracle] nantanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nantan id:nantan

oracleã«é–¢ã™ã‚‹nantanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã‚ªãƒ©ã‚¯ãƒ«ã€ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¢ãƒ—ãƒªå‘ã‘JavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒOracle JETã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚SPAã€UIã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã€ãƒ¬ã‚¹ãƒãƒ³ã‚·ãƒ–å¯¾å¿œãªã©ã‚’çµ±åˆ
ã‚ªãƒ©ã‚¯ãƒ«ã¯ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‘ã‘ã®JavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒOracle JETã€ï¼ˆOracle JavaScript Extension Toolkitï¼‰ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã—ã¾ã—ãŸã€‚ Oracle JETã¯ã€28ã®è¨€èªžã¨160ä»¥ä¸Šã®ãƒã‚±ãƒ¼ãƒ«ã‚’å‚™ãˆãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å›½éš›åŒ–ã‚„ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãƒ™ãƒ¼ã‚¹ã®Single Page Applicationé–‹ç™ºãªã©ã‚’ã‚µãƒãƒ¼ãƒˆã€‚åŒç¤¾ãŒä»¥å‰ã‹ã‚‰å…¬é–‹ã—ã¦ã„ãŸUIã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã®ã€ŒAlta UIã€ã®ã»ã‹ã€JQueryã€KnockoutJSã€RequireJSã€Hammerãªã©ã‚‚å«ã¾ã‚ŒãŸçµ±åˆçš„ãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ãªã£ã¦ã„ã¾ã™ã€‚ ä¸‹è¨˜ã¯Oracle JETã§é–‹ç™ºã•ã‚ŒãŸãƒ‡ãƒ¢ã‚µã‚¤ãƒˆã®ç”»é¢ã€‚ Oracle JETã«ã¯ã€ãƒ•ã‚©ãƒ¼ãƒ ã‚„ãƒœã‚¿ãƒ³ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ãƒ‡ãƒ¼ã‚¿ã‚°ãƒªãƒƒãƒ‰ãªã©ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚„ã€ç·šã‚°ãƒ©ãƒ•ã€æ£’ã‚°ãƒ©ãƒ•ã€ãƒ‘ã‚¤ãƒãƒ£ãƒ¼ãƒˆã€ã‚¨ãƒªã‚¢ãƒãƒ£ãƒ¼ãƒˆãªã©å¤šæ•°ã®ã‚°ãƒ©ãƒ•
nantan 2016/03/03
oracle

javascript
ãƒªãƒ³ã‚¯
ã‚«ãƒ¼ã‚½ãƒ«ãƒ»ãƒ«ãƒ¼ãƒ—å‡¦ç† - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle PL/SQL å…¥é–€
æ˜Žç¤ºã‚«ãƒ¼ã‚½ãƒ«ã¨æš—é»™ã‚«ãƒ¼ã‚½ãƒ« ã‚«ãƒ¼ã‚½ãƒ«(CURSOR) ã¨ã¯ã€ä¸»ã«å•ã„åˆã‚ã›ï¼ˆãƒ‡ãƒ¼ã‚¿æ“ä½œã‚‚å«ã‚€ï¼‰ã‚’è¡Œãªã†ãŸã‚ã®æƒ…å ±ã‚’ç®¡ç†ã™ã‚‹ä½œæ¥é ˜åŸŸã‚’ã‚ã‚‰ã‚ã™ãŸã‚ã®ã€Œã‚¿ã‚°ã€ã®ã‚ˆã†ãªã‚‚ã®ã§ã‚ã‚‹ã€‚ ã“ã®ã‚«ãƒ¼ã‚½ãƒ«ã«ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒåå‰ã‚’ä»˜ã‘ã¦ã„ã‚‹ã‚‚ã®ã‚’ æ˜Žç¤ºã‚«ãƒ¼ã‚½ãƒ« ã¨å‘¼ã¶ã€‚ æš—é»™ã‚«ãƒ¼ã‚½ãƒ« ã§ã¯ Oracle ã«ã‚ˆã£ã¦ç”¨æ„ã•ã‚Œã¦ã„ã‚‹åå‰ã®ç„¡ã„ä½œæ¥é ˜åŸŸã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã€‚ æ˜Žç¤ºã‚«ãƒ¼ã‚½ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã‚«ãƒ¼ã‚½ãƒ«ã®å†åˆ©ç”¨ã‚„ %ROWTYPE ãªã©ã‚’ä½¿ç”¨ã—ã¦ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ï¼ˆå®šç¾©æƒ…å ±ï¼‰ã‚’ PL/SQL ä¸Šãªã©ã‹ã‚‰å®¹æ˜“ã«ãƒ•ã‚§ãƒƒãƒï¼ˆå–ã‚Šå‡ºã—ï¼‰ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ æš—é»™ã‚«ãƒ¼ã‚½ãƒ«ã‚’ä½¿ç”¨ã—ãŸ SELECT æ–‡ã«ã‚ˆã‚‹ FOR ãƒ«ãƒ¼ãƒ— ã‚«ãƒ¼ã‚½ãƒ«ã‚’å®šç¾©ã›ãšã« FOR ã®åˆ¶å¾¡ãƒªã‚¹ãƒˆã«è¨˜è¿°ã™ã‚‹ã“ã¨ã§ãƒ«ãƒ¼ãƒ—å¤‰æ•°ã«çµæžœãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä»£å…¥ã™ã‚‹ã€‚ SELECT ã—ãŸçµæžœã‚»ãƒƒãƒˆãŒå˜åœ¨ã—ãªã„å ´åˆã«ã¯ãƒ«ãƒ¼ãƒ—å‡¦ç†ã¯ç™ºç”Ÿã—ãªã„ã€‚ SQLPlus ã®å ´åˆã«ã¯å®Ÿè¡Œã®å‰ã« SET SERV
nantan 2012/07/06
oracle

SQL
ãƒªãƒ³ã‚¯
ALTER SYSTEM KILL SESSION | Oracle
ãƒãƒƒã‚¯ã‚’è§£é™¤ã™ã‚‹ã«ã¯ã€ãã®ãƒãƒƒã‚¯ã‚’ä¿æŒã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’åˆ‡ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’åˆ‡ã‚‹ã«ã¯ ALTER SYSTEM KILL SESSION 'SID,SERIAL#' ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ãƒãƒƒã‚¯ã‚’ä¿æŒã—ã¦ã„ã‚‹SID,SERIAL#ã¯ã€V$SESSIONã¨V$LOCKã‹ã‚‰å–å¾—ã—ã¾ã™ã€‚ SELECT SID,SERIAL#,USERNAME,STATUS,SERVER,SCHEMANAME,OSUSER,MACHINE,PROGRAM FROM V$SESSION WHERE SID IN (SELECT SID FROM V$LOCK)
nantan 2012/07/06
oracle

session
ãƒªãƒ³ã‚¯
é€šçŸ¥ã®ä½¿ç”¨
4 é€šçŸ¥ã®ä½¿ç”¨ é€šçŸ¥ã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã£ã¦ã€ç‰¹å®šã®ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆã€ã‚¤ãƒ™ãƒ³ãƒˆã¾ãŸã¯å•é¡ŒãŒç™ºç”Ÿã—ãŸã¨ãã«Enterprise Managerç®¡ç†è€…ã«é€šçŸ¥ã§ãã¾ã™ã€‚ ç®¡ç†ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®é‡è¦ãªéƒ¨åˆ†ã¨ã—ã¦ã€é€šçŸ¥ã¯ã€ç‰¹å®šã®ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆã€ã‚¤ãƒ™ãƒ³ãƒˆã¾ãŸã¯å•é¡Œã®ç™ºç”Ÿæ™‚ã«ã‚ªãƒšãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ãƒ»ã‚·ã‚¹ãƒ†ãƒ ãƒ»ã‚³ãƒžãƒ³ãƒ‰(ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å«ã‚€)ã‚„PL/SQLãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®å®Ÿè¡Œãªã©ã®ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚‚å®Ÿè¡Œã§ãã¾ã™ã€‚ã“ã®æ©Ÿèƒ½ã«ã‚ˆã‚Šã€ITãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’è‡ªå‹•åŒ–ã§ãã¾ã™ã€‚ãŸã¨ãˆã°ã€ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆ(ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹•ä½œ(ç¨¼åƒ/åœæ¢)ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã®ç›£è¦–ãªã©)ãŒç™ºç”Ÿã—ãŸã¨ãã«ã€é€šçŸ¥ã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã£ã¦OSã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä»‹ã—ã¦ç¤¾å†…ã®ãƒˆãƒ©ãƒ–ãƒ«ãƒ»ãƒã‚±ãƒƒãƒˆã‚’è‡ªå‹•çš„ã«é–‹ãã€æ‹…å½“ã®ITã‚¹ã‚¿ãƒƒãƒ•ãŒé©æ™‚ã«å¿œç”ã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ ã¾ãŸã€Enterprise Managerã®é€šçŸ¥ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€Simple Network Management Protocol(SNMP)ãƒˆãƒ©ãƒƒãƒ—ã‚’ä½¿
nantan 2012/06/26
oracle

oem
ãƒªãƒ³ã‚¯
OTN Japan ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
Enterprise Manager Cloud Control Oracle Enterprise Managerã¯ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚ªãƒ³ãƒ—ãƒ¬ãƒŸã‚¹ç®¡ç†ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã™ã€‚ Oracle Enterprise Managerã¯ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚ªãƒ³ãƒ—ãƒ¬ãƒŸã‚¹ç®¡ç†ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã™ã€‚Oracleãƒ‡ãƒ—ãƒã‚¤ãƒ¡ãƒ³ãƒˆç’°å¢ƒãŒãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼æ¥ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã‚ã‚‹ã®ã‹Oracle Cloudã«ã‚ã‚‹ã®ã‹ã«é–¢ä¿‚ãªãã€ãƒ‡ãƒ—ãƒã‚¤ãƒ¡ãƒ³ãƒˆç’°å¢ƒå…¨ä½“ã‚’å˜ä¸€ç”»é¢ã‹ã‚‰ç®¡ç†ã§ãã¾ã™ã€‚Oracle Enterprise Managerã¯ã‚ªãƒ©ã‚¯ãƒ«ã®è£½å“ã‚¹ã‚¿ãƒƒã‚¯ã¨ç·Šå¯†ã«çµ±åˆã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€Oracleã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ãŠã‚ˆã³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ‰ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®ç®¡ç†ã¨è‡ªå‹•åŒ–ã«å¯¾ã—ã€å¸‚å ´ã‚’ãƒªãƒ¼ãƒ‰ã™ã‚‹ã‚µãƒãƒ¼ãƒˆã‚’æä¾›ã—ã¾ã™ã€‚ ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ–ãƒªãƒ¼ãƒ•ï¼ˆUSï¼‰ï¼šEnterprise Managerã‚’ä½¿ç”¨ã™ã‚‹ãƒã‚¤ãƒ–ãƒªãƒƒãƒ‰ãƒ»ã‚¯ãƒ©ã‚¦ãƒ‰
nantan 2012/06/21
oracle

oem

document
ãƒªãƒ³ã‚¯
Oracle 11gã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å¤§æ–‡å—ãƒ»å°æ–‡å—ã®åŒºåˆ¥ - shibainu55æ—¥è¨˜
Oracle Databaseã¯11gã‹ã‚‰ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æ–‡å—åˆ—ã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§åŒºåˆ¥ã™ã‚‹ä»•æ§˜ã«ãªã£ãŸã€‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®è¦³ç‚¹ã§è€ƒãˆã‚Œã°ã“ã‚Œã¯å½“ç„¶å¥½ã¾ã—ã„ä»•æ§˜ã§ã¯ã‚ã‚Šã€Oracleç¤¾ã‚‚ã“ã®å‹•ä½œã‚’ãã®ã¾ã¾å¤‰æ›´ã›ãšä½¿ç”¨ã™ã‚‹ã“ã¨ã‚’æŽ¨å¥¨ã—ã¦ã„ã‚‹ã€‚ãŸã ã€å®Ÿéš›ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»æ§‹ç¯‰ã®ç¾å ´ã§ã¯æ—¢å˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æ–‡å—åˆ—ãŒãƒãƒ¼ãƒ‰ã‚³ãƒ¼ãƒ‰ã•ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã£ãŸã‚Šã€ã‚¯ãƒ©ã‚µãƒåž‹ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦å¤šæ•°ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆç«¯æœ«ã«å¤§/å°æ–‡å—ã‚’åŒºåˆ¥ã•ã‚Œãšã«è¨å®šã•ã‚ŒãŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒã‚ã‚‹å ´åˆãªã©ã€Oracleå´ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤§/å°æ–‡å—åŒºåˆ¥ã‚’ã™ã‚‹ã“ã¨ãŒå¿…ãšã—ã‚‚å¬‰ã—ããªã„ã‚±ãƒ¼ã‚¹ã‚‚ã‚ã‚‹ã€‚ä»Šå›žã¯ãã‚“ãªå ´åˆã®å¯¾å‡¦æ–¹æ³•ã«é–¢ã™ã‚‹å‚™å¿˜éŒ²ã€‚ ã¾ãšã€Oracle 11gã«ãŠã‘ã‚‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å¤§/å°æ–‡å—ã‚’åŒºåˆ¥ã«é–¢ã‚ã‚‹è¦ç´ ã¨ã—ã¦ã¯ã€Oracleã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒ•ã‚¡ã‚¤ãƒ«(orapwãƒ•ã‚¡ã‚¤ãƒ«)ã¨åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã€ŒSET SEC_CASE_SENSITIV
nantan 2012/05/03
oracle

ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
HDDã‚’SSDã«ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚Œã ã‘é€Ÿããªã‚‹ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå®Ÿé¨“
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹éš›ã«ã¯ã€é«˜ã„æ€§èƒ½ã‚’å¼•ãå‡ºã™ãŸã‚ã«ç‰©ç†è¨è¨ˆã‚’ã—ã€ã‚¹ã‚ãƒ¼ãƒžã‚’å·¥å¤«ã—ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ãŒã¤ãã«è¡Œã‚ã‚Œã¦ãã¾ã—ãŸã€‚ æ€§èƒ½ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ãŸã„ãŒã„HDDã«ã‚ã‚Šã€ã„ã‹ã«ãã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ã‹ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã§ã™ãŒã€æœ€è¿‘ã§ã¯æ€§èƒ½å‘ä¸Šã®ãŸã‚ã®æ¦å™¨ã¨ã—ã¦ã€HDDã‚ˆã‚Šã‚‚ãšã£ã¨ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã®é«˜ã„SSDãŒæ³¨ç›®ã•ã‚Œã¦ã„ã¾ã™ã€‚SSDã¯HDDã¨ç½®ãæ›ãˆã‚‹ã ã‘ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã£ãŸãæ‰‹ã‚’åŠ ãˆãšã«æ€§èƒ½å‘ä¸Šã‚’å¯èƒ½ã«ã™ã‚‹æ‰‹æ®µã¨ã—ã¦éžå¸¸ã«é…åŠ›çš„ã§ã™ã€‚ HDDã®ä»£ã‚ã‚Šã«SSDã‚’åˆ©ç”¨ã—ãŸã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã¯ã©ã‚Œã ã‘å‘ä¸Šã™ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå…±åŒæ¤œè¨¼ã‚’è¡Œã„ã€ãã®çµæžœã‚’ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦å…ˆé€±ç™ºè¡¨ã—ã¾ã—ãŸï¼ˆå‚è€ƒã€Œæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€š ãƒ•ãƒ©ãƒƒã‚·ãƒ¥æŠ€è¡“æ´»ç”¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–ã‚’å…±åŒæ¤œè¨¼ã€ï¼‰ã€‚ ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã§ã¯ã€HDDã®ä»£ã‚ã‚Š
nantan 2010/05/18
ã‚µãƒ¼ãƒ

hdd

ssd

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

oracle
ãƒªãƒ³ã‚¯
Another way to monitor Oracle - ZABBIX Forums
Hi to everyone, i've wrote within a workmate a plugin for zabbix to monitor oracle instances. This script work on serverside and don't use zabbix send, but simply the zabbix server run some script and collect data from oracle instances. This plugin is server-centric because for me is more simple manage and upgrade a single application. The work that is done with zabora is simply great,and i've rea
nantan 2010/03/29
check_ora

zabbix

oracle
ãƒªãƒ³ã‚¯
Oracle and Perl
nantan 2010/03/05
sqlplus

perl

oracle
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆSQLPLUSï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ ä¾‹ï¼‘ï¼‰ã€€è¡¨ã€Œempã€ã®SELECTçµæžœã‚’ã€ã‚«ãƒ³ãƒž','åŒºåˆ‡ã‚Šã®CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã€Œc\tmp\emp.csvã€ã«å‡ºåŠ›ã—ã¾ã™ã€‚ SQL> set echo off SQL> set linesize 1000 SQL> set pagesize 0 SQL> set trimspool on SQL> set feedback off SQL> set colsep ',' SQL> spool c:\temp\emp.csv SQL> select * from emp; E01,D01,åå—ï¼‘ã€€ã€€,åå‰ï¼‘ã€€ã€€, 10 E02,D01,åå—ï¼’ã€€ã€€,åå‰ï¼’ã€€ã€€, 50 E03,D02,åå—ï¼“ã€€ã€€,åå‰ï¼“ã€€ã€€, 100 SQL> spool off
nantan 2009/11/27
ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€set pagesize 0

SQL

oracle
ãƒªãƒ³ã‚¯
ORACLE/SQL*Plus - centromezzo wiki
nantan 2009/11/27
ã‚«ãƒ©ãƒ è¡Œã‚’éžè¡¨ç¤ºã€SQL*PLUSã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€set pagesize 0

Oracle

SQL
ãƒªãƒ³ã‚¯
ãƒ©ãƒƒãƒï¼ˆLatchï¼‰ã¨Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - /* Grid Thinking */
ãƒ©ãƒƒãƒã¯ã€ã‚‚ã¨ã‚‚ã¨å®¶ã®ãƒ‰ã‚¢ãªã©ã«ã‹ã‘ã‚‹ãƒã‚§ãƒ¼ãƒ³ã®ã“ã¨ã§ã€ Oracleã§ã¯ã‚·ã‚¹ãƒ†ãƒ ãƒ»ã‚°ãƒãƒ¼ãƒãƒ«é ˜åŸŸï¼ˆSGAï¼‰ã®ãƒ¡ãƒ¢ãƒªãƒ¼æ§‹é€ ã‚’ä¿è·ã™ã‚‹ãŸã‚ã«Oracleã§ä½¿ç”¨ã•ã‚Œã‚‹ä¸‹ä½ãƒ¬ãƒ™ãƒ«ã®å†…éƒ¨ãƒãƒƒã‚¯ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ ã‚„ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãƒ»ãƒ—ãƒã‚»ã‚¹ã¯ã€SGAã§æ“ä½œã‚’è¡Œã†éš›ã«ã€ãƒ¡ãƒ¢ãƒªãƒ¼æƒ…å ±ãŒå¤‰æ›´ã•ã‚Œãªã„ã‚ˆã†ã« éžå¸¸ã«çŸã„é–“ï¼ˆ1ç§’ã‚‚ãªã„ï¼‰ã€ãƒ©ãƒƒãƒã‚’ç²å¾—ã—ã¾ã™ã€‚è¤‡æ•°ã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ©ãƒƒãƒ ã‚’ç²å¾—ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ç«¶åˆãŒãŠãã€å¾…æ©ŸãŒç™ºç”Ÿã—ã¾ã™ã€‚ ãƒ©ãƒƒãƒã®ç›®çš„ã¯ã€åŒæ™‚ã«è³‡æºã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ã§å£Šã—ã‚ã„ã‚„ä¸æ•´åˆã‚’é˜²ãã‚‚ã®ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã—ã¾ã™ã€‚ ç›®çš„ã¯ãƒãƒƒã‚¯ã¨åŒã˜ã§ã™ãŒã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«è¦‹ã›ã‚‹ã®ãŒãƒãƒƒã‚¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«è¦‹ã›ãªã„ã®ãŒãƒ©ãƒƒãƒã§ã™ã€‚ ä¸€èˆ¬çš„ã«ãƒ©ãƒƒãƒã«ã¯ã€å…±æœ‰ãƒ¢ãƒ¼ãƒ‰ã¨æŽ’ä»–ãƒ¢ãƒ¼ãƒ‰ãŒã‚ã‚‹ã‚ˆã†ã§ã™ã€‚å…±æœ‰ãƒ¢ãƒ¼ãƒ‰åŒå£«ã¯èªã¿å–ã‚Šã‚’è¨±ã—ã€ ç›¸æ‰‹ãŒæŽ’ä»–ãƒ¢ãƒ¼ãƒ‰ã ã£ãŸã‚‰èªã¿å–ã‚Šã¯è¨±ã•ã‚Œãªã„ã§ã™ã€€ã“ã‚Œã‚‚ã€å¯èƒ½ãªã‚‰ä¸¦è¡Œåº¦ã‚’ä¸Šã’ã‚‹ãŸã‚
nantan 2009/05/27
ãƒ©ãƒƒãƒï¼Ÿ

Oracle
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµåˆé †åºã‚’åˆ¶å¾¡ã—ãŸã„ï¼ - SQL> shutdown abort
ã¨ã„ã†ã“ã¨ã§ã€ä»Šæ—¥ã¯ãƒ’ãƒ³ãƒˆå¥ã«ã¤ã„ã¦å°‘ã—ã€‚ çš†ã•ã‚“ã‚ˆãä½¿ã†ã§ã‚ã‚ã† ORDEREDãƒ’ãƒ³ãƒˆ ã¨ ã¡ã‚‡ã£ã¨ãƒžã‚¤ãƒŠãƒ¼ãª LEADINGãƒ’ãƒ³ãƒˆ ã«ã¤ã„ã¦ã§ã™ã€‚ ORDEREDãƒ’ãƒ³ãƒˆ ã¨ LEADINGãƒ’ãƒ³ãƒˆ ã¯ã€Œçµåˆé †åºã«é–¢ã™ã‚‹ãƒ’ãƒ³ãƒˆã€ã§ã™ã€‚ ã¤ã¾ã‚Šã€ã“ã‚Œã‚’ä½¿ç”¨ã™ã‚Œã°ã€ FROMå¥ä»¥ä¸‹ã«è¨˜è¿°ã—ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµåˆé †åºã‚’ ãƒ¦ãƒ¼ã‚¶å´ã§åˆ¶å¾¡ã§ãã‚‹ã¨ã„ã†ã‚ã‘ã§ã™ã€‚ ãŸã¨ãˆã°ã€ä¸‹è¨˜ã®ã‚ˆã†ãªSQLãŒã‚ã‚Šã¾ã™ã€‚ SQL> explain plan for 2 SELECT EMP2.ENAME ,DEPT.DNAME ,EMP2.JOB 3 FROM EMP EMP1 4 ,EMP EMP2 5 ,DEPT 6 WHERE EMP1.MGR = EMP2.EMPNO 7 AND EMP2.DEPTNO = DEPT.DEPTNO 8 AND EMP1.ENAME = 'TURNER'; è§£æžã•ã‚Œã¾ã—ãŸã€‚ ã™ã§ã«
nantan 2009/05/12
oracle
ãƒªãƒ³ã‚¯
ã€Ž[Oracle] ORA-01000ã‚¨ãƒ©ãƒ¼ã®å›žé¿æ–¹æ³•ã€
å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‡¦ç†ã—ãŸå ´åˆãªã©ã« ORA-01000 æœ€å¤§ã‚ªãƒ¼ãƒ—ãƒ³ãƒ»ã‚«ãƒ¼ã‚½ãƒ«æ•°ã‚’è¶…ãˆã¾ã—ãŸã€‚ ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã¯æ–‡å—é€šã‚Šä¸€åº¦ã«ã‚ªãƒ¼ãƒ—ãƒ³ã§ãã‚‹ã‚«ãƒ¼ã‚½ãƒ«ã®æœ€å¤§æ•°ã‚’è¶…ãˆãŸã“ã¨ã‚’ç¤ºã™ã‚¨ãƒ©ãƒ¼ã§ã™ã€‚ Oracleã§åŒæ™‚ã«ã‚ªãƒ¼ãƒ—ãƒ³ã§ãã‚‹ã‚«ãƒ¼ã‚½ãƒ«ã®æœ€å¤§æ•°ã¯åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿OPEN_CURSORSã§è¨å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã§ã¯å¢—ã‚„ã›ã°ã„ã„ã˜ã‚ƒãªã„ã‹ã¨å®‰æ˜“ã«è€ƒãˆã¦ã—ã¾ã„ãŒã¡ã§ã™ãŒã€ãã†æ˜“ã€…ã¨è§£æ±ºã§ãã‚‹ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ OPEN_CURSORSã®å€¤ã‚’å¢—ã‚„ã›ã°ã€ç¢ºã‹ã«ä¸Šè¨˜ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ç¢ºçŽ‡ã‚’æ¸›ã‚‰ã™ã“ã¨ã¯ã§ãã¾ã™ãŒã€é€†ã«ãƒªã‚½ãƒ¼ã‚¹ã‚’å¤šãæ¶ˆè²»ã™ã‚‹ã‚ˆã†ã«ãªã‚Šã€Oracleã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå…¨ä½“çš„ã«ä½Žä¸‹ã—ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ ãã‚‚ãã‚‚ã‚«ãƒ¼ã‚½ãƒ«ã¨ã„ã†ã‚‚ã®è‡ªä½“ãƒªã‚½ãƒ¼ã‚¹ã‚’å¤šãæ¶ˆè²»ã™ã‚‹ã‚‚ã®ãªã®ã§ã€å¤§é‡ã«ä½¿ç”¨ã™ã‚‹ã¨ã„ã†ã®ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿çš„ã«å¥½ã¾ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ã§ã™ã‹ã‚‰ã€ä¸Šè¨˜ã®ã‚¨ãƒ©ãƒ¼ã‚’å›ž
nantan 2009/05/11
java

oracle

sql
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆWITHå¥ï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ ORACLE9iã‹ã‚‰ã€WITHå¥ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¾ã—ãŸã€‚ WITHå¥ã§æŒ‡å®šã—ãŸï¼³ï¼±ï¼¬ã®çµæžœã¯ã€VIEWã®æ§˜ã«SQLå†…éƒ¨ã‹ã‚‰å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã‚Œã«ã‚ˆã‚Šã€ã‚¤ãƒ³ãƒ©ãƒ³ã‚¤ãƒ³ãƒ“ãƒ¥ãƒ¼ã€ã‚„ã€å†…éƒ¨çµåˆã€å¤–éƒ¨çµåˆã‚’ä½¿ã£ãŸè¤‡é›‘ãªï¼³ï¼±ï¼¬ã‚’åˆ†ã‹ã‚Šã‚„ã™ãè¦‹ã›ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ æ§‹æ–‡ã¯ã€WITHã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®å¾Œã«ã€å‰¯å•åˆã›SQLçµæžœã®VIEWåã¨ã€ASã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã«ç¶šã„ã¦æ‹¬å¼§å†…ã«ï¼³ï¼±ï¼¬ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€å‰¯å•åˆã›çµæžœã®ã€Œview01ã€ã¨è¡¨ã€Œtable01ã€ã‚’å†…éƒ¨çµåˆã—ã¦ã„ã¾ã™ã€‚ with view01 as ( select column99 from table99 where column01 = '01' ) select view01.column99, table01.column77 from table01, view01 where table01.column99
nantan 2009/04/08
WITHå¥ã§è¦‹ã‚„ã™ã

oracle

SQL
ãƒªãƒ³ã‚¯
bashã‹ã‚‰sqlplusã¸ã®å¼•æ•°æ¸¡ã—ã¨æˆ»ã‚Šå€¤å–å¾— - Pumpkin Moonshine
ãƒ»bashã‹ã‚‰sqlplusã¸å¼•æ•°ã‚’æ¸¡ã—ã¦æˆ»ã‚Šå€¤ã‚’å–å¾—ã—ã¾ã™ã€‚ ãƒ»sqlplusã®çµ‚äº†ã§ã€Œquit æ–‡å—åˆ—ã€ã¨ã—ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã®ã§ ä¸é–“ãƒ•ã‚¡ã‚¤ãƒ«ã‚’çµŒç”±ã•ã›ã¾ã—ãŸã€‚ ãƒ»ä¸é–“ãƒ•ã‚¡ã‚¤ãƒ«çµŒç”±ã®æ–¹æ³•ã¯ã‹ãªã‚Šç„¡ç†ã‚„ã‚Šãªæ°—ãŒã—ã¾ã™ã€‚ ã‚‚ã†å°‘ã—è‰¯ã„æ–¹æ³•ãŒçŸ¥ã‚ŠãŸã„ã§ã™ã€‚ #!/bin/sh # TMP_FILE="./hoge.tmp" #Â sqpluså‡¦ç† functionÂ printSqlplusÂ { ${ORACLE_HOME}/bin/sqlplusÂ -sÂ scott/tigerÂ >>EOFÂ <Â /dev/null SETÂ HEADINGÂ OFF SETÂ ECHOÂ OFF SETÂ FEEDBACKÂ OFF SETÂ PAGESIZEÂ 0 SETÂ TRIMSPOOLÂ ON SETÂ TERMOUTÂ OFF SETÂ LINESIZEÂ 1000 SPOOLÂ ${TMP_FILE}; SELECTÂ 'Hell
nantan 2009/03/11
shell

bash

oracle

sql
ãƒªãƒ³ã‚¯
Oracle SQL ã® Hintï¼ˆãƒ’ãƒ³ãƒˆï¼‰å¥ã¾ã¨ã‚ï¼ˆä¸€è¦§ï¼‰
ä»¥å‰ã€€Oracle SQLã®Hintå¥ã®ãƒ¡ãƒ¢ã€€ã£ã¦è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸãŒã€ã“ã‚ŒãŒæ„å¤–ã¨æ¤œç´¢ã•ã‚Œã¦ã„ã‚‹ã‚“ã§ã™ã‚ˆãã€‚ ãƒãƒƒãƒå‡¦ç†å‘ã‘ SQL ã§ã®è©±ãªã®ã§ã™ãŒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’çªãè©°ã‚ã‚‹ã¨ã©ã†ã—ã¦ã‚‚ãƒ’ãƒ³ãƒˆå¥ã«é ¼ã‚‰ã–ã‚‹ã‚’å¾—ãªã„ã‚±ãƒ¼ã‚¹ãŒã§ã¦ãã¾ã™ã€‚ãªã‚“ã§ãã£ã¡ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½¿ã†ã‚“ã ã‚ˆã‰ã€œã¨ã‹ã€ä½•æ•…ã‹ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã—ã¦ã‚‹ã¨ãã¨ã‹ãƒ»ãƒ»ãƒ»ãã®ä»–ã‚‚ã‚ã‚‚ã‚ Oracle ã®ã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®åˆ¤å®šã«æ³£ãã‚’è¦‹ã‚‹ã‚±ãƒ¼ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ ãã‚“ãªåƒ•ã‚‚ãƒ’ãƒ³ãƒˆå¥ã‚’ä½¿ã„ã“ãªã›ã¦ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æ˜¨æ—¥ã€€Oracle ä½¿ã„ãªã‚‰æ‰‹å…ƒã«ãŠããŸã„ï¼ - æ›¸è©• - è©³è§£Oracle ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€€ã‚’æ›¸ã„ã¦ã„ã¦çŸ¥ã‚‰ãªã„ãƒ’ãƒ³ãƒˆå¥ãŒã‚ã¾ã‚Šã«ãŸãã•ã‚“ã‚ã£ãŸã®ã§ä¸€è¦§ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚æƒ…å ±ã‚½ãƒ¼ã‚¹ã¯ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã™ã€‚ç„¡æ–™ã§å…¥æ‰‹ã§ãã¦ã€æœ€ã‚‚æ£ã—ãã€æœ€ã‚‚æƒ…å ±é‡ãŒå¤šã„æ•™ç§‘æ›¸ã§ã™ã€‚ï¼ˆã‚ã‹ã‚Šã‚„ã™ã„ã‹ã©ã†ã‹ã¯å…¨ãåˆ¥å•é¡Œã§ã™ã€‚ï½—ï¼‰ â€»ä¸‹è¨˜ã‚µã‚¤ãƒˆã®é–²
nantan 2009/01/26
oracle

tips

DB
ãƒªãƒ³ã‚¯
DBA Tips(åˆ†æžãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°) - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
åˆ†æžãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é–¢é€£ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°( ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ã€éš ã—åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã€ DML ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ•°) ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ã®å–å¾— ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥ SELECT ROUND(100 * SUM(PINHITS) / SUM(PINS), 2) "LIBRARY HIT RATE(%)" FROM V$LIBRARYCACHE ; ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥ SELECT ROUND(100 * SUM(GETS-GETMISSES) / SUM(GETS), 2) "DICTIONARY HIT RATE(%)" FROM V$ROWCACHE ; é–¢é€£ åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã€€SHARED_POOL_SIZE (å…±æœ‰ãƒ—ãƒ¼ãƒ«) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒãƒ•ã‚¡ãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥ SELECT ROUND(100- 100 * SUM(DECODE(NAME,'physical reads',VA
nantan 2008/12/11
oracle

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
[ã¦] Windows XPã«Rubyå‘¨ã‚Šã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã¦Oracleã«ç¹‹ã„ã§ã¿ã‚‹ãƒ¡ãƒ¢: å¤§é˜ªã¦ãã¨ãƒ¼æ—¥è¨˜
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ >Oracle Rubyãƒ‘ã‚½ã‚³ãƒ³ãƒ»ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ> Windows XPã«Rubyå‘¨ã‚Šã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã¦Oracleã«ç¹‹ã„ã§ã¿ã‚‹ãƒ¡ãƒ¢ Â« ã„ã–å¥åº·è¨ºæ–ï¼ | ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ | ãã‚‡ã†ã¯(Bl ogPet) Â» 2007/04/05 Windows XPã«Rubyå‘¨ã‚Šã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã¦Oracleã«ç¹‹ã„ã§ã¿ã‚‹ãƒ¡ãƒ¢ æ€ã„ç«‹ã£ãŸãŒå‰æ—¥ ã¨è¨€ã†ã“ã¨ã§æ–°å¹´åº¦æ—©ã€…ã€ã©ã†ã—ã¦ã‚‚ã€ŒWindows PCã®Rubyã‹ã‚‰Oracleã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã—ã¦ãƒ›ã‚²ãƒ›ã‚²ã—ã¦ã€ä½•ã‚‰ã‹ã®å½¢ã§ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã—ã¦ã¿ãŸã„ã€ã¨ã„ã†æ€ã„ã«é§†ã‚‰ã‚Œã¾ã—ãŸã€‚ãã†ãªã£ãŸã‚‰ã‚‚ã†ã€å¾Œå…ˆè€ƒãˆãšã«GO!ã§ã™ã€‚ å¹¸ã„ã«ã—ã¦ãƒãƒƒãƒˆä¸Šã«ã¯ã€å…ˆé”ãŒå…¬é–‹ã—ã¦ã„ã‚‹æœ‰ç›Šãªæƒ…å ±ãŒæ•°å¤šãã‚ã‚Šã¾ã™ã®ã§ã€å¾Œã¯ãã‚Œã‚‰ã‚’å‚è€ƒã«ã—ã¦ã€ã¨ã«ã‹ãã‚„ã£ã¦ã¿ã‚‹ã ã‘ã§ã™ã€‚ä½•ã‹ã®å‚è€ƒã«ãªã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã®ã§ã€ãƒ¡ãƒ¢ã ã‘ã¯æ®‹ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãŠã‹ã—ãªéƒ¨åˆ†ã¨ã‹ã‚ã£ãŸã‚‰
nantan 2008/11/27
ruby

oracle
ãƒªãƒ³ã‚¯
ã€ã‚¤ãƒ³ãƒ•ã‚©ã‚·ãƒ¼ã‚¯ã€‘Infoseek ï¼š æ¥½å¤©ãŒé‹å–¶ã™ã‚‹ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ
æ—¥é ƒã‚ˆã‚Šæ¥½å¤©ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã¨ã“ã‚å¤§å¤‰ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ãŒã€ç¾åœ¨ã€ç·Šæ€¥ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚’è¡Œã‚ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ãŠå®¢æ§˜ã«ã¯ã€ç·Šæ€¥ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«ã‚ˆã‚Šã€ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã—ã¦ãŠã‚Šã€èª ã«ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã€‚ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒçµ‚äº†æ¬¡ç¬¬ã€ã‚µãƒ¼ãƒ“ã‚¹ã‚’å¾©æ—§ã„ãŸã—ã¾ã™ã®ã§ã€ ä»Šã—ã°ã‚‰ããŠå¾…ã¡ã„ãŸã ã‘ã¾ã™ã‚ˆã†ã€ãŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚
nantan 2008/11/27
oracle
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸