[B! db][oracle] shin-uemonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shin-uemon id:shin-uemon

dbã¨oracleã«é–¢ã™ã‚‹shin-uemonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

OTN Japan - Oracle9i ç‰©ç†è¨è¨ˆï¼šç¬¬6éƒ¨ æ–ç‰‡åŒ–ã®è§£æ±º
ç´„åŠå¹´ã«æ¸¡ã£ã¦è§£èª¬ã—ã¦ããŸã€ŒOracle9iç‰©ç†è¨è¨ˆã€ã‚‚ã¨ã†ã¨ã†æœ€çµ‚å›žã«ãªã‚Šã¾ã—ãŸã€‚ç‰©ç†è¨è¨ˆã®ã†ã¡çš†ã•ã‚“ãŒèˆˆå‘³ã‚’æŒã¡ãã†ãªã¨ã“ã‚ã‚’ä¸å¿ƒã«è§£èª¬ã—ã¦ããŸã¤ã‚‚ã‚Šã§ã—ãŸãŒã„ã‹ãŒã§ã—ãŸã§ã—ã‚‡ã†ã‹ï¼Ÿä»Šå¾Œã‚‚iSeminarã‚„OTNã‚’é€šã˜ã¦OracleDirect ã®ãƒ¡ãƒ³ãƒãƒ¼ã§æŠ€è¡“æƒ…å ±ã‚’ç™ºä¿¡ã—ã¦ã¾ã„ã‚Šã¾ã™ã®ã§ã”æœŸå¾…ãã ã•ã„ã€‚ ã¯ã˜ã‚ã« ç¬¬5éƒ¨ã®è§£èª¬ã‚’å—ã‘ã¦ã€æœ¬é …ã§ã¯æ–ç‰‡åŒ–ã®è§£æ±ºæ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã„ãŸã—ã¾ã™ã€‚æ–ç‰‡åŒ–ã®è§£æ¶ˆã®ä½œæ¥ã¯å‡ºæ¥ã‚‹é™ã‚Šç™ºç”Ÿã—ãªã„æ–¹ãŒDBAã®æ–¹ã€…ã«ã¨ã£ã¦ã‚‚å¹¸ã›ã ã¨æ€ã„ã¾ã™ã®ã§ã€è©²å½“ã®æ–ç‰‡åŒ–ãŒç™ºç”Ÿã—ã«ãããªã‚‹äº‹å‰ã®å¯¾ç–ã«ã¤ã„ã¦ã‚‚å‡ºæ¥ã‚‹é™ã‚Šè§£èª¬ã—ã¾ã™ã€‚ æ–ç‰‡åŒ–è§£æ±ºã®æ¦‚è¦ æ–ç‰‡åŒ–ã®è§£æ±ºæ–¹æ³•ã¯ã€æ–ç‰‡åŒ–ç¾è±¡ã«ã‚ˆã‚Šã‚ã‚‹ç¨‹åº¦ã¯ç•°ãªã‚Šã¾ã™ãŒã€å…±é€šã®æ‰‹æ³•ã§è§£æ±ºã§ãã‚‹ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã€‚ã¾ãšã¯æ–ç‰‡åŒ–ç¾è±¡ã”ã¨ã®è§£æ±ºæ–¹æ³•ã‚’ä¸€è¦§ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚æ¬¡ç« ä»¥é™ã§å€‹åˆ¥ã«è§£èª¬ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚
shin-uemon 2008/12/23
oracle

db
ãƒªãƒ³ã‚¯
.NETã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰Oracleã«æŽ¥ç¶šã™ã‚‹ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€.NETã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰Oracleã¸æŽ¥ç¶šã™ã‚‹ãŸã‚ã®æœ€å–„ã®æ–¹æ³•ã¯ã€Oracleç¤¾ãŒæä¾›ã—ã¦ã„ã‚‹ã€ŒOracle Data Provider for .NETã€ï¼ˆä»¥ä¸‹ã€ODP.NETï¼‰ã§ã™ã€‚ãªãœã€ODP.NETãŒæœ€å–„ã®æ–¹æ³•ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®2ã¤ã®ç†ç”±ã‹ã‚‰ã§ã™ã€‚OracleæŽ¥ç¶šã«æœ€é©åŒ–ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã„Oracleç‹¬è‡ªã®æ©Ÿèƒ½ãŒä½¿ç”¨å¯èƒ½ ã€€ä»Šå›žã¯ã€ã“ã®ODP.NETã‚’ä½¿ç”¨ã™ã‚‹ãŸã‚ã«å¿…è¦ãªæº–å‚™ã¨Oracleã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ç°¡å˜ãªã‚³ãƒ¼ãƒ‰ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å¯¾è±¡èªè€…Visual Basicã€ã‚‚ã—ãã¯C#ã‚’ä½¿ã£ã¦ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œã£ãŸã“ã¨ã®ã‚ã‚‹äººã€‚Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¯¾å¿œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã«èˆˆå‘³ã®ã‚ã‚‹äººã€‚ å¿…è¦ãªç’°å¢ƒã€€Microsoft .NET Framework 1.0 ä»¥ä¸ŠãŒå¿…è¦ã§ã™ã€‚ã¾ãŸã€ODP.NETã‹ã‚‰æŽ¥ç¶šå¯èƒ½ãªOracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€Oracle8i R8
shin-uemon 2008/06/13
oracle

db

.net
ãƒªãƒ³ã‚¯
Visual Studio 2005ã‹ã‚‰Oracleã‚’æ“ä½œã™ã‚‹ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€Oracleã¯ã€Oracle Developer Tools for Visual Studioï¼ˆä»¥ä¸‹ã€ODTï¼‰ã¨å‘¼ã°ã‚Œã‚‹Visual Studioã®ã‚¢ãƒ‰ã‚¤ãƒ³ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ODTã¯æ¬¡ã®ã‚ˆã†ã«ã•ã¾ã–ã¾ãªæ©Ÿèƒ½ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚Oracleã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ãƒ‡ã‚¶ã‚¤ãƒŠã¨ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰è‡ªå‹•ã‚³ãƒ¼ãƒ‰ç”Ÿæˆæ©Ÿèƒ½PL/SQLã‚³ãƒ¼ãƒ‰ãƒ»ã‚¨ãƒ‡ã‚£ã‚¿Oracleãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦Oracleå•åˆã›ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦çµ±åˆã•ã‚ŒãŸãƒ˜ãƒ«ãƒ— ã€€ä»Šå›žã¯ã€ODTã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®šæ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã€ODTã®ç›®çŽ‰æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹PL/SQLã‚³ãƒ¼ãƒ‰ãƒ»ã‚¨ãƒ‡ã‚£ã‚¿ã‚’ä½¿ç”¨ã—ãŸã€Oracleã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£é–‹ç™ºã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚å¯¾è±¡èªè€…Visual Studio 2005ã‚’ä½¿ç”¨ã—ãŸã“ã¨ã®ã‚ã‚‹äººã€‚Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¯¾å¿œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã«èˆˆå‘³ã®ã‚ã‚‹äººã€‚ å¿…è¦ãªç’°å¢ƒã€€Visual Studio 2005 Standard Editio
shin-uemon 2008/06/13
ã»ã»ã†

oracle

db

.net
ãƒªãƒ³ã‚¯
è¡¨ãƒãƒƒã‚¯ã®ç¨®é¡žã¨ç›¸äº’é–¢ä¿‚ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
â— ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ Ã— ãƒãƒƒã‚¯ã®å–å¾—ã¯ä¸å¯èƒ½ â–² ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ã§ã‚ã‚‹ãŒåˆ¥ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‹ã‚‰ã®åŒä¸€è¡Œã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯å¾…æ©Ÿã•ã›ã‚‰ã‚Œã‚‹(TXå¾…æ©Ÿ) â–¼ ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ã§ã‚ã‚‹ãŒåˆ¥ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‹ã‚‰ã® ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼åˆ¶ç´„ã€ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ ã«è©²å½“ã™ã‚‹è¡Œã® INSERT ã¯å¾…æ©Ÿã•ã›ã‚‰ã‚Œã‚‹(TXå¾…æ©Ÿ) â–² â–¼ ã«é–¢ã—ã¦ï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåˆ†æ•£ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å ´åˆã«ã¯åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã‚ˆã£ã¦ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆãŒç™ºç”Ÿã™ã‚‹ã€‚ å‚è€ƒ â‡’ ORA-02049: ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆ: åˆ†æ•£ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒãƒãƒƒã‚¯ã‚’å¾…æ©Ÿã—ã¦ã„ã¾ã™ã€‚ å…±æœ‰ãƒãƒƒã‚¯ã¨æŽ’ä»–ãƒãƒƒã‚¯ å…±æœ‰ãƒãƒƒã‚¯ å…±æœ‰ãƒãƒƒã‚¯ã¨ã¯ä¸»ã«å‚ç…§ã‚’è¡Œã†éš›ã«æŽ›ã‘ã‚‹ãƒãƒƒã‚¯ã§ã‚ã‚Šè¤‡æ•°è¨å®šã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ã—ã‹ã— SELECT ã®åº¦ã«ãƒãƒƒã‚¯ã‚’æŽ›ã‘ã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ã‚„è¡¨å®šç¾©ãŒå¤‰æ›´ã•ã‚Œã‚‹ã¨å›°ã‚‹æ“ä½œã®ã¨ãã«ã ã‘æŽ›ã‘ã‚‰ã‚Œã‚‹ã€‚ ä¾‹: æ›´æ–°äºˆå®šã®è¡Œã‚’å®£è¨€ã—ã¦ SELECT ã™ã‚‹(RSãƒãƒƒã‚¯)ã€ã‚¤ãƒ³ãƒ‡ãƒƒ
shin-uemon 2007/09/04
database

db

oracle

tips
ãƒªãƒ³ã‚¯
ãƒ—ãƒã¨ã—ã¦ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ãƒªã‚«ãƒãƒªåŸºç¤ŽçŸ¥è˜ï¼ˆ1/4ï¼‰ ï¼ ï¼ IT
ä¸»ãªå†…å®¹ --Page 1-- â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã ã‘ã§ã¯ä¸å®Œå…¨ â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä¸»ãªå½¹å‰² --Page 2-- â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—è¨ˆç”»ã®ç«‹ã¦æ–¹ â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—è¦ä»¶ --Page 3-- â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å¯¾è±¡ã‚’æ±ºå®šã™ã‚‹ â–¼ã„ã¤ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã™ã‚‹ã®ã‹ã‚’æ±ºå®šã™ã‚‹ --Page 4-- â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•ã‚’æ±ºå®šã™ã‚‹ â–¼ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä¿æŒæœŸé–“ã¨å–å¾—å…ˆåª’ä½“ã‚’æ±ºå®šã™ã‚‹ ä»Šå›žã‹ã‚‰å§‹ã¾ã‚‹æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ãƒªã‚«ãƒãƒªã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ãƒªã‚«ãƒãƒªã®é‡è¦æ€§ã€ãã—ã¦å®Ÿéš›ã®å®Ÿè¡Œæ–¹æ³•ã‚’ç†è§£ã—ã¦ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ç¬¬1å›žã§ã¯ã€ã¾ãšæ¦‚è¦ã‚’ç†è§£ã—ã¦ã„ãŸã ããŸã‚ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é™å®šã›ãšã«ã€ã”ãä¸€èˆ¬çš„ãªä¾‹ã‚’æŒ™ã’ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã ã‘ã§ã¯ä¸å®Œå…¨ ã‚‚ã—ã€çš†ã•ã‚“ãŒã„ã¾ä½¿ã£ã¦ã„ã‚‹ãƒ‘ã‚½ã‚³ãƒ³ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ãŒã€æ€¥ã«å£Šã‚Œã¦ã—ã¾ã£ãŸã¨ã—ãŸã‚‰ã€ã©ã†ã—ã¾ã™ã‹ï¼Ÿ ã€Œä»•äº‹ãŒä½•
shin-uemon 2007/08/08
database

db

oracle

é‹ç”¨
ãƒªãƒ³ã‚¯
ç¾Žå¥³è£¸ä½“açº§æ¯›ç‰‡,å…è´¹è§‚çœ‹æˆäººç¾žç¾žè§†é¢‘ç½‘ç«™,ä¸°æ»¡å¤šæ¯›çš„é™°æˆ·è§†é¢‘,å¥³æ•™å¸ˆæ¨é›ªçš„æ€§è¡ç”Ÿæ´»
ç¾Žå¥³è£¸ä½“açº§æ¯›ç‰‡,å…è´¹è§‚çœ‹æˆäººç¾žç¾žè§†é¢‘ç½‘ç«™,ä¸°æ»¡å¤šæ¯›çš„é™°æˆ·è§†é¢‘,å¥³æ•™å¸ˆæ¨é›ªçš„æ€§è¡ç”Ÿæ´»,avæ¿€æƒ…äºšæ´²ç”·äººçš„å¤©å ‚å›½è¯,é«˜æ¸…å˜¼çš‡bestialitysex,äººäººå¦»äººäººæ¾¡äººäººçˆ½è§†é¢‘,japanesematureä¹±åå°‘å¦‡,æŽè€æ±‰åƒå«©è‰å¼€èŠ±è‹žå°é›ª,freeæ€§æ¬§ç¾Ž,ä¸æ–‡å—å¹•ç²¾å“äºšæ´²ä¸€åŒº
shin-uemon 2007/08/06
oracle

db

tips
ãƒªãƒ³ã‚¯
Oracle Database 10g Express Edition
Multitenant: Get isolation, agility, and economies of scale by managing multiple Pluggable Databases inside your Oracle Multitenant Container Database In-Memory: Support real-time analytics, business intelligence, and reports by keeping your important data in the Oracle Database In-Memory column store Partitioning: Enhance performance, availability, and manageability of your database with data par
shin-uemon 2007/08/02
Oracle 10g ç„¡å„Ÿç‰ˆ

database

db

oracle
ãƒªãƒ³ã‚¯
1