[B! oracle] hiroto-kã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hiroto-k id:hiroto-k

oracleã«é–¢ã™ã‚‹hiroto-kã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

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

ç†å±ˆã§è€ƒãˆã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° | Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ æŠ€è¡“æˆ¦ç•¥éƒ¨ãƒ–ãƒã‚°]
æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢/ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã‹ã‚‰æŠ€è¡“æƒ…å ±ã‚’ã¯ã˜ã‚ã€ä¸–ã®ä¸ã®ãŸã‚ã«ãªã‚‹ã“ã¨ã‚„ç¤¾å†…ã®ã“ã¨ãªã©ã‚’ç™ºä¿¡ã—ã¦ã¾ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‹‰å¼·ä¼šOracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLInnoDB ã“ã‚“ã«ã¡ã¯ã€ç¾½å±±ã§ã™ã€‚ä»Šå›žã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§å°‘ã—è¸ã¿è¾¼ã‚“ã å†…å®¹ã§ã™ã€‚é€”ä¸ã§æ¯”è¼ƒå¯¾è±¡ã¨ã—ã¦MySQLã‚‚ç™»å ´ã—ã¾ã™ã€‚ æ—¥é ƒã‹ã‚‰SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æ©Ÿä¼šãŒã‚ã£ã¦ãã‚Œãªã‚Šã«å¾—æ„ã¨ã—ã¦ã„ã‚‹ã®ã«ã€ãã‚Œã§ã‚‚ãªãœã‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒã§ãªã„SQLã«æ‚©ã‚“ã çµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ è¬Žã®é…ã„ç¾è±¡ã¯ç‰¹ã«å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãªã£ã¦ãã‚‹ã¨ç™ºç”Ÿã—ãŒã¡ãªã®ã§ã™ãŒã€é€Ÿã„å ´åˆã‚‚é…ã„å ´åˆã‚‚å¿…ãšç†ç”±ãŒã‚ã‚Šã¾ã™ã€‚ãã“ã§æœ¬è¨˜äº‹ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦æ„å¤–ã¨è¦‹è½ã¨ã•ã‚ŒãŒã¡ãªãƒãƒ¼ãƒ¬ãƒ™ãƒ«ãªéƒ¨åˆ†ã«ç€ç›®ã—ã¦ã€ã•ã‚‰ã«ä¸€æ©ä¸Šã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å¿…è¦ãªçŸ¥è˜ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã‚’æ›¸ããã£ã‹ã‘ã¨ãªã£ãŸã®ã¯ç§ãŸ
hiroto-k 2020/10/02
ãƒ‡ã‚£ã‚¹ã‚¯I/Oã¾ã§è€ƒãˆãŸDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è‰¯è¨˜äº‹

db

oracle

performance

tuning
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
hiroto-k 2009/05/13
db

oracle

mysql

postgres
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆDBMS_METADATA.GET_DDLï¼‰
æŒ‡å®šã•ã‚ŒãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ï¼¤ï¼¤ï¼¬æ–‡ã‚’å–å¾—ã—ã¾ã™ã€‚ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¿ã‚¤ãƒ—ã€€ï¼šã€€TABLEã€VIEWãªã©ã®å–å¾—ã™ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ç¨®é¡ž ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåã€€ï¼šã€€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ãƒ“ãƒ¥ãƒ¼åãªã©ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆå ã‚¹ã‚ãƒ¼ãƒžã€€ï¼šã€€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®æ‰€æœ‰è€…ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã€ãƒã‚°ã‚¤ãƒ³ä¸ã®ãƒ¦ï¼ã‚¶ãƒ¼ â€»å¼•æ•°ã®æŒ‡å®šã¯ã€å…¨ã¦å¤§æ–‡å—ã§æŒ‡å®šã—ã¾ã™ SQL> set long 2000 SQL> set heading off SQL> SQL> select 2ã€€ã€€ dbms_metadata.get_ddl('TABLE','EMP') 3 ã€€ã€€from dual; CREATE TABLE "TEST"."EMP" ( ã€€ "EMP_ID" CHAR(5), "DEPT_ID" CHAR(5), "EMP_NAME" VARCHAR2(10), "EMP_DATE" DATE, "SALARY" NUMBER(5,0), PRIMAR
hiroto-k 2008/11/20
oracle
ãƒªãƒ³ã‚¯
ãƒ¡ãƒ¢å¸³: Oracleã®Hierarchical Queryå¥ï¼ˆCONNECT BYï¼‰
ã¡ã‚‡ã£ã¨ãšã¤æ›¸ãè¶³ã—ã¾ã™ã€‚ ã„ã‚ã‚†ã‚‹éšŽå±¤çš„ã‚¯ã‚¨ãƒªã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®Oracleã®æ©Ÿèƒ½ã€Hierarchical Query. SELECT * FROM TAB_A WHERE ~~ -- ã“ã£ã‹ã‚‰Hierarchical Query Clause START WITH /* éšŽå±¤ã®ãƒ«ãƒ¼ãƒˆã¨ãªã‚‹è¡Œã®æ¡ä»¶ */ CONNECT BY /* è¡Œã®è¦ªåé–¢ä¿‚ã‚’æ±ºã‚ã‚‹æ¡ä»¶ */ hierarchical query clauseã¯WHEREæ–‡ã®ç›´å¾Œã«æŒ‡å®šã—ã¾ã™ã€‚ã¤ã¾ã‚Šã€WHEREæ–‡ã®ã‚ã¨ã§START WITHã‚„CONNECT BYãŒè©•ä¾¡ã•ã‚Œã‚‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚ æ“¬ä¼¼åˆ— CONNECT_BY_ISLEAF è©²å½“è¡ŒãŒLEAF(è‘‰)ã«ç›¸å½“ã™ã‚‹å ´åˆã¯1ãŒå…¥ã‚Šã¾ã™ã€‚ãã‚Œä»¥å¤–ã®å ´åˆã¯0ãŒå…¥ã‚Šã¾ã™ã€‚å…·ä½“çš„ã«è¨€ã†ã¨ã€CONNECT BYæ¡ä»¶ãŒæˆç«‹ã›ãšã€ãã‚Œä»¥ä¸Šåä¾›ã‚’ç”Ÿæˆã§ããã†ã‚‚ãªã„å ´åˆã«1ã«ãªã‚Šã¾ã™ã€‚CONNECT
hiroto-k 2008/07/04
connect by

oracle
ãƒªãƒ³ã‚¯
http://matsystem.net/2006/08/oracle.html
hiroto-k 2008/07/04
connect by

oracle
ãƒªãƒ³ã‚¯
Oracleäº’æ› é–‹ç™ºè€…ã‚¬ã‚¤ãƒ‰
ä¾‹ ã‚»ã‚¯ã‚·ãƒ§ãƒ³3.4.3ã®æœ€å¾Œã®ä¾‹ã§ã‚ã‚‹ã€historyã€branchesã€ãã—ã¦ accountsã®3ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¸ãƒ§ã‚¤ãƒ³ã‹ã‚‰ã€Txã¨ã„ã†åå‰ã®ãƒ“ãƒ¥ãƒ¼ã¯ç”Ÿæˆã•ã‚Œã¦ã„ã¾ã™ã€‚ CREATE VIEW tx AS SELECT h.mtime, h.delta, b.bid, a.aid FROM history h, branches b, accounts a WHERE h.bid = b.bid AND h.aid = a.aid; EXPLAIN SELECT * FROM tx; QUERY PLAN -------------------------------------------------------------------------------------- Nested Loop (cost=1.11..207.95 rows=26 width=20) -> Ha
hiroto-k 2008/04/14
viewã«å«ã¾ã‚Œã‚‹tableã«hintå¥ã‚’é©ç”¨ã™ã‚‹æ–¹æ³•

oracle

sql
ãƒªãƒ³ã‚¯
Bestellung
Die besten Softwares fÃ¼r Ihren Laptop Viele von uns besitzen gar keinen fest installierten Rechner mehr zu Hause, da Laptops mittlerweile eben so viel Arbeitsspeicher und einen vergleichbaren Prozessor bieten. Auch die SpeicherkapazitÃ¤t eines Laptops genÃ¼gt mittlerweile, um sogar eine Vielzahl von Filmen speichern zu kÃ¶nnen. Aktuelle Laptop-Modelle enthalten zudem eine SSD-Festplatte, die sehr sch
hiroto-k 2008/03/17
eclipse

oracle

plugin
ãƒªãƒ³ã‚¯
Oracle |ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ
OCIã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’é€šã˜ã¦NVIDIA AI EnterpriseãŒåˆ©ç”¨å¯èƒ½ã¨ãªã‚‹ã“ã¨ã§ã€ãŠå®¢æ§˜ã¯AIãƒ„ãƒ¼ãƒ«ã«ç°¡å˜ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã€AIã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã‚’å‚™ãˆãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹ç¯‰ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚
hiroto-k 2008/02/06
oracle

performance
ãƒªãƒ³ã‚¯
Array DML (å¤§é‡ãƒ¬ã‚³ãƒ¼ãƒ‰ä¸€æ‹¬INSERT/UPDATE/DELETE) â€• Teppi Technology
Array DML (å¤§é‡ãƒ¬ã‚³ãƒ¼ãƒ‰ä¸€æ‹¬INSERT/UPDATE/DELETE) ã“ã“ã§ã¯Array DMLï¼ˆãƒãƒ«ã‚¯ãƒ»ãƒã‚¤ãƒ³ãƒ‰ï¼‰ã®åˆ©ç”¨æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ å¤§é‡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸€åº¦ã«æ›´æ–°ã™ã‚‹ã®ã«ã€ãƒ«ãƒ¼ãƒ—ã®å†…éƒ¨ã§1ä»¶æ›´æ–°ã®DMLï¼ˆINSERTæ–‡ã‚„UPDATEæ–‡ãªã©ï¼‰ã‚’å‘¼ã³å‡ºã™ã®ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨Oracleã‚µãƒ¼ãƒé–“ã§ã®é€šä¿¡ãŒä½•å¾€å¾©ã‚‚ç™ºç”Ÿã—ã¦ã—ã¾ã„éžåŠ¹çŽ‡ã§ã™ã€‚ 1000ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«æŒ¿å…¥ã™ã‚‹å‡¦ç†ã®æ–¹æ³•ã«ã¤ã„ã¦ã€ä»¥ä¸‹ã«3ã¤ã®æ–¹æ³•ã‚’æ¯”è¼ƒã—ã¾ã™ãŒã€DOAã§ã¯ã€Oracle8iä»¥é™ã§åˆ©ç”¨å¯èƒ½ãªArray DMLï¼ˆãƒãƒ«ã‚¯ãƒ»ãƒã‚¤ãƒ³ãƒ‰ï¼‰ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ«ãƒ¼ãƒ—ã®ä¸ã§1ä»¶æŒ¿å…¥ã®SQLã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³•ï¼æœ€ã‚‚é…ã„æ–¹æ³•ã§ã™ 1000ä»¶åˆ†ã®INSERTæ–‡ã‚’ã€ä¸€ã¤ã®PL/SQLç„¡åãƒ–ãƒãƒƒã‚¯ã«è¨˜è¿°ã—ã¦ä¸€åº¦ã«å®Ÿè¡Œã™ã‚‹æ–¹æ³• Array DML ã‚’ç”¨ã„ã¦ã€ä¸€æ‹¬æ›´æ–°ã‚’è¡Œã†æ–¹æ³•ï¼ˆOracle8iä»¥é™ã§æœ‰åŠ¹ï¼‰ 1.ãƒ«ãƒ¼
hiroto-k 2008/01/29
oracle

tips
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ã€PHPãƒ‰ãƒ©ã‚¤ãƒã€ŒOCI8ã€ã‚’æ‹¡å¼µ
Oracleã¯ç±³å›½æ™‚é–“10æœˆ10æ—¥ã€PHPå‘ã‘ã€ŒOracle Call Interfaceï¼ˆOCI8ï¼‰ã€ãƒ‰ãƒ©ã‚¤ãƒã®æ‹¡å¼µã¨ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ãƒªãƒªãƒ¼ã‚¹ã‚’ç™ºè¡¨ã—ãŸã€‚ æ‹¡å¼µã•ã‚ŒãŸãƒ‰ãƒ©ã‚¤ãƒOCI8ã§ã¯ã€è¤‡æ•°ã®ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒé–“ã§ã‚µãƒ¼ãƒå´ã®æŽ¥ç¶šãƒ—ãƒ¼ãƒªãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚‹ã€‚ã“ã‚Œã«ã‚ˆã‚ŠOracleã¯ã€ã‚¦ã‚§ãƒ–ä¸Šã®å€‹äººç”¨ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚’é–‹ç™ºã™ã‚‹ãŸã‚ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã‚ã‚‹PHPã‚’å¯¾è±¡ã¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹æ‹¡å¼µæ€§ã€å¯ç”¨æ€§ã€äº’æ›æ€§ãŒå‘ä¸Šã™ã‚‹ã¨æœŸå¾…ã—ã¦ã„ã‚‹ã€‚ ã‚µãƒ¼ãƒãŒã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã•ã‚ŒãŸã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã‚ã‚‹æ—¢å˜ã®PHPã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ãªãæ–°ã—ã„æŽ¥ç¶šãƒ—ãƒ¼ãƒªãƒ³ã‚°æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ Oracleã®è£½å“ç®¡ç†ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ã§ã‚ã‚‹John Deebæ°ã¯ã€OCI8ã¯ã€Œä»»æ„ã®æ™‚ç‚¹ã«ãŠã„ã¦ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã«æŽ¥ç¶šã—ã€ã‚ã‚‰ã‚†ã‚‹ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ãªãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ã‚’åˆ¶å¾¡
hiroto-k 2007/10/12
php

oracle
ãƒªãƒ³ã‚¯
Oracle é‹ç”¨è¡“ ï¼š ã“ã‚Œã ã‘ã§ã»ã¼ååˆ†ã€‚é‹ç”¨ç›£è¦–ã‚¹ã‚¯ãƒªãƒ—ãƒˆ
ä¸€å¿œã“ã‚“ãªæ„Ÿã˜ã®ãƒ¬ãƒãƒ¼ãƒˆãŒã‚ãŒã£ã¦æ¥ã‚‹ã¨ã„ã†ã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚çµæžœã¯ä»®æƒ³çš„ãªç’°å¢ƒã‚’æƒ³å®šã—ãŸã‚‚ã®ã§ã€å†…å®¹ã¯ã§ãŸã‚‰ã‚ã«ã—ã¦ã‚ã‚Šã¾ã™ã€‚ =================== ora_perf_report.sh 2007/06/11 20:43:48 HostName: dev1 Database: testdb =================== /*---------------------------------------------------------------------------*/ // æœ€ä½Žé™å¿…è¦ãª shared_pool_sizeã®æ¸¬å®š /*---------------------------------------------------------------------------*/ SHARED_POOL_SIZE ---------------- 29
hiroto-k 2007/09/19
oracle

é‹ç”¨
ãƒªãƒ³ã‚¯
MySQLä½¿ã„ãŒOracleã‚’ä½¿ã£ãŸã¨ãã®ã‚«ãƒ«ãƒãƒ£ãƒ¼ã‚·ãƒ§ãƒƒã‚¯ - ãƒ•ãƒ„ãƒ¼ãªæ—¥å¸¸
ã¨ã„ã†ã»ã©ã§ã‚‚ãªãã€ã¾ãã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ä¸Šæ„Ÿã˜ãŸç›¸é•ç‚¹ãªã© SQLã®æ§‹æ–‡ã§é•ã†ã¨ã“ã‚ãŒã‚ã‚‹ æœ€åˆã«é©šã„ãŸã®ã¯LIMITå¥ã€‚ã‚ã‚Œã£ã¦Oracleã§ã¯ãªã„ã‚“ã§ã™ãã€‚PostgreSQLã§ã‚‚ä½¿ãˆã¦ã„ãŸã‹ã‚‰SQLæ¨™æº–ã ã¨ã°ã‹ã‚Šæ€ã£ã¦ã„ãŸã€‚SQLæ¨™æº–ã ãã†ã§ã™ãŒã€ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹RDBMSã¯å°‘æ•°æ´¾ã®ã‚ˆã†ã§ã™ã€‚ Oracleã§ã¯ROWNUMã¨ã„ã†ä»®æƒ³çš„ãªã‚«ãƒ©ãƒ ã‚’WHEREå¥ã§æ¡ä»¶æŒ‡å®šã™ã‚‹ã®ãŒæ£ã—ã„ã‚ˆã†ã ã€‚ ä»–ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦åˆ¥åã‚’ã¤ã‘ã‚‹ã¨ãã®"AS"ã‚’ä½¿ã‚ãªã„ã“ã¨ã€‚ã“ã‚Œã¯ASã‚’å…¥ã‚Œãªã„ã§ã‚¹ãƒšãƒ¼ã‚¹ã®å¾Œã«åˆ¥åã‚’ã¤ã‘ã‚‰ã‚Œã‚‹ã®ã§ç°¡å˜ã ãŒã€æ°—ä»˜ãã¾ã§ã¯ä½•æ•…æ§‹æ–‡ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã®ã‹æ‚©ã‚“ã§ã—ã¾ã£ãŸã€‚ MySQLã®æ‹¡å¼µæ§‹æ–‡ãŒã®è»’ä¸¦ã¿ä½¿ãˆãªã„ã®ã¯ã€ã¾ãå½“ç„¶ã€‚REPLACEã¨ã‹UPDATEæ–‡ã®IGNOREã¨ã‹ä¾¿åˆ©ã§ã”éƒ½åˆä¸»ç¾©çš„ãªæ©Ÿèƒ½ãŒä½¿ãˆãªã„ã®ã¯ã¡ã‚‡ã£ã¨æ®‹å¿µã€‚ æŽ¥ç¶šã®ã‚³ã‚¹ãƒˆãŒé«˜ã„ MySQLã¯æŽ¥ç¶šãŒé€Ÿã„ãŸã‚ã«ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—
hiroto-k 2007/06/27
oracle

mysql
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ é€†å¼•ãSQLæ¯”è¼ƒ [Â å…±é€šäº‹é …Â ]Â [Â ORACLEÂ ]Â [Â MSSQLÂ ]Â [Â SSAÂ ]Â [Â PostgresÂ ]Â [Â MySQLÂ ]Â [Â JetÂ ]Â Last Updated. 14-May-2006 Since 08-May-2001 â– ã¯ã˜ã‚ã« è¤‡æ•°ã® RDBMS ã‚’ä½¿ã£ãŸçµŒé¨“ãŒã‚ã‚‹äººãªã‚‰ã€ãŠã‚ã‹ã‚Šã‹ã¨æ€ã„ã¾ã™ãŒã€SQL ã¯ RDBMS ã«ã‚ˆã£ã¦ç•°ãªã‚‹éƒ¨åˆ†ãŒçµæ§‹ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯å„ RDBMS ã«ãŠã‘ã‚‹ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ãŸãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ ç‰¹å®šã® RDBMS ã‚’æŒã¡ä¸Šã’ãŸã‚Šã€è²¶ã‚ãŸã‚Šã™ã‚‹ã®ãŒç›®çš„ã§ã¯ãªã„ã®ã§èª¤è§£ãªãã‚ˆã†ã€‚ ã¾ãŸã€é–“é•ã„ã«ã¤ã„ã¦ã®ã”æŒ‡æ‘˜ã‚„ã€Žã“ã†ã—ãŸæ–¹ãŒåŠ¹çŽ‡çš„ã ã€ãªã©ã®ã”æ„è¦‹ã‚‚å¤§æ“è¿Žã§ã™ã€‚ å¯¾è±¡ã¨ã—ã¦ã„ã‚‹ã®ã¯ä»¥ä¸‹ã® RDBMSã§
hiroto-k 2007/04/02
sql

db

oracle

mysql

postgres
ãƒªãƒ³ã‚¯
OTN Japan - Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ æ€§èƒ½å¯¾ç–æ©Ÿèƒ½ ã€œ Statspackã¨Diagnostics Packã‚’ä½¿ã„ã“ãªã™ ã€œ ç¬¬1å›ž Statspackã¨Diagnostics Packã®æ¦‚è¦ã¨ä½¿ç”¨æ–¹æ³•
NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨ã€€æŠ€è¡“SEéƒ¨é–€ã€€DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— å‚ä¸‹ã€€å¾¹ Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½å¯¾ç–ã®é‡è¦ãªæ©Ÿèƒ½ã€ã€ŒStatspackã€ã‚„ã€ŒOracle Enterprise Manager 10g Diagnostics Packã€(â€»ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ©ã‚¤ã‚»ãƒ³ã‚¹)ã®åˆ©ç”¨ãƒã‚¤ãƒ³ãƒˆã‚’ãŠä¼ãˆã—ã¾ã™ã€‚ä½¿ã‚ãªã„ã¨"ã‚‚ã£ãŸã„ãªã„"æ©Ÿèƒ½ã§ã™ï¼(Diagnostics Packã®æœ‰ç„¡ã«ã‚ˆã‚‹é•ã„ã¯ã“ã“) - INDEX - â– 1 ã¯ã˜ã‚ã« â– 2 æ€§èƒ½å¯¾ç–æ¦‚è¦ â– 3 Statspack ãƒ» 3.1 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ» 3.2 ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ ãƒ» 3.3 ãƒ¬ãƒãƒ¼ãƒˆä½œæˆ ãƒ» 3.4 StatspackãŒä¸å‘ããªã‚±ãƒ¼ã‚¹ â– 4 Diagnostics Pack ãƒ» 4.1 Automatic Workload Repository (AWR) ãƒ» 4.2 Automatic Database
hiroto-k 2007/03/26
oracle

tuning
ãƒªãƒ³ã‚¯
Oracle Instant Client 10.2.0.1ã‚’åˆ©ç”¨ã—ãŸå ´åˆã€çªç„¶DBã¸æŽ¥ç¶šãŒã§ããªããªã‚‹ç¾è±¡ - ç©ã¿é‡ããŸæ—¥ã€…
ã€è¿½è¨˜ã€‘(2008/02/13) ä»¥ä¸‹ã®å¯¾å¿œã‚’è¡Œã£ãŸã®ã§ã™ãŒã€ã¾ãŸåŒæ§˜ã®ç¾è±¡ãŒç™ºç”Ÿã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚Oracle Instant Client 10.2.0.3ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã§å•é¡ŒãŒè§£æ¶ˆã•ã‚Œã¦ã„ã‚Œã°ã‚ˆã„ã®ã§ã™ãŒ... Oracle Instant Clientã‚’ä½¿ã£ãŸç’°å¢ƒã§ã‚µãƒ¼ãƒãŒãƒãƒ³ã‚°ã‚¢ãƒƒãƒ—ã™ã‚‹ - ç©ã¿é‡ããŸæ—¥ã€… â€»ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒã‚ã‚‹ã‚ˆã†ãªã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã‚’ã‚‚ã†å°‘ã—åˆ†ã‹ã‚Šã‚„ã™ãå¤‰æ›´ã—ã¾ã—ãŸã€‚ ä»¥ä¸‹ã®OSãŠã‚ˆã³ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢çµ„ã¿åˆã‚ã›ã§å‹•ã‹ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãŒã‚ã‚Šã¾ã™ã€‚ Red Hat Enterprise Linux WS v.3 Apache2.0.x (prefork) PHP4.4.x Oracle Instant Client 10.2.0.1 çªç„¶ä½•ã®å‰è§¦ã‚Œã‚‚ãªãOracleã¸æŽ¥ç¶šãŒã§ããªããªã‚Šã¾ã—ãŸã€‚Apacheã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã‚’è¦‹ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼
hiroto-k 2007/03/22
oracle
ãƒªãƒ³ã‚¯
ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã«å‘ã„ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ MySQL ? Oracle ?
Catalyst-Plugin-Session-Store-DBIC ã¨ã‹æ¤œè¨¼ã—ã¦ã¾ã™ã€‚ã§å‰ã‹ã‚‰æ°—ã«ãªã£ã¦ã¯ã„ãŸã®ã§ã™ãŒã€Perl ç•Œã§ã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨ã„ãˆã°ã»ã¼å…¨ã¦ MySQL ãŒå‰æã£ã½ã„ä½œã‚Šã«ãªã£ã¦ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã§ã‚‚æ¥å‹™ã§ä½¿ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ Oracle ã§ã—ã¦ã€ã†ã€œã‚“ãƒ»ãƒ»ãƒ»ã©ã†ã™ã£ã¹ã‹ãªãã€œã¨æ€ã£ã¦ã¾ã—ãŸã€‚ ã§ã€è©¦ã—ã« Oracle ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã™ã‚‹ãŸã‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã¤ãã£ã¦ã¿ã¾ã—ãŸã€‚Oracle ã¯ VACHAR2 åž‹ã¨ã‹ã¯ 4000 æ–‡å—ã¾ã§ã—ã‹æ‰±ãˆãªã„ã®ã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ä½¿ã†ã«ã¯ã¡ã‚‡ã£ã¨ç‰©è¶³ã‚Šãªã„ãƒ‡ãƒ¼ã‚¿åž‹ã€‚CLOB åž‹ã‚’ä½¿ãˆã°è§£æ±ºã§ãã‚‹ã‚“ã§ã™ãŒã€DBI ãƒ™ãƒ¼ã‚¹ã«ã„ã‚ã„ã‚ã¨æŒ‡å®šã—ã¦ã‚ã’ãªã„ã¨ãƒ€ãƒ¡ã€‚ã—ã‹ã‚‚å¤šåˆ†é…ã„ã€‚é…ã„ã¨æŽ¨æ¸¬ã—ã¦ã„ãŸã‹ã‚‰ã€ä»Šã¾ã§ LOB ã‚„ LONG åž‹ã¯ã‚ãˆã¦ä½¿ã£ã¦ãã¾ã›ã‚“ã§ã—ãŸã€‚ session æ ¼ç´ã«ä½¿ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ ã¯ã“ã‚“ãª
hiroto-k 2007/03/22
mysql

oracle

performance
ãƒªãƒ³ã‚¯
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
hiroto-k 2007/03/16
sql

security

mysql

oracle
ãƒªãƒ³ã‚¯
Oracle è±†è¾žå…¸
Oracle è±†è¾žå…¸ æ³¨æ„ ï¼š ã“ã‚Œã¯ã€ç§å€‹äººã®è¦šãˆæ›¸ãã§ã‚ã‚Šã€ä½•ã‚‚ä¿è¨¼ã™ã‚‹ã‚‚ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚è‡ªå·±è²¬ä»»ã§ãŠèªã¿ä¸‹ã•ã„ã€‚ èªå–å°‚ç”¨ã®ãƒ¦ãƒ¼ã‚¶æ¨©é™ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ä½œæˆã•ã‚Œã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«ãƒ’ãƒ³ãƒˆã‚’ä¸Žãˆã‚‹ã«ã¯ çµ±è¨ˆæƒ…å ±ã®å–ã‚Šæ–¹ ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚³ãƒ¼ãƒ‰â€00000â€ ã€Œã»ã‹ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒåŒã˜ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ãƒ»ãƒ»ãƒ»ã€ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ Version ã®å–å¾— åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®å–å¾— ï¼³ï¼§ï¼¡é ˜åŸŸå–å¾— ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ã‚’è¡¨ç¤ºã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã®ç·å®¹é‡ã€ä½¿ç”¨å®¹é‡ã€ç©ºãå®¹é‡å–å¾— ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã®çŠ¶æ³ç¢ºèª ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆå–å¾— ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹å†…ã®ç©ºãé ˜åŸŸ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹å†…ã®ç©ºãé ˜åŸŸã‚’çµåˆã™ã‚‹ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã€€è¦æ±‚æ•°ã€å†èªè¾¼æ•°ã€ãƒ’ãƒƒãƒˆçŽ‡ ãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥ã€€è¦æ±‚æ•°ã€å†èªè¾¼æ•° ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒãƒƒãƒ•ã‚¡ï½¥ãƒ’ãƒƒãƒˆçŽ‡ å…±æœ‰ãƒ—ãƒ¼ãƒ«å†…ã®ç©ºãé ˜åŸŸã®å¤§ãã•å–å¾— ãƒ¡ãƒ¢ãƒª
hiroto-k 2007/02/21
oracle

tips
ãƒªãƒ³ã‚¯
Oracle Database 10g Express Edition(XE) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã€Red Hatç³»Linuxç·¨ã€‘
Oracle Database 10g Express Editionï¼ˆXEï¼‰ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã€Red Hatç³»Linuxç·¨ã€‘ ã“ã“ã§ã¯ã€Oracle Database 10g Express Edition Releaseã‚’Fedora CORE 4ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ‰‹é †ã‚’ã¾ã¨ã‚ã¾ã™ã€‚ redhatç³»ã®Linuxï¼ˆRed Hat, Suse, MIRACLE, Red Flag, Hannsoft, Ubuntu, Mandrivaï¼‰ã§ã‚ã‚Œã°ã€åŒæ§˜ã®æ‰‹é †ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¯èƒ½ã ã¨æ€ã„ã¾ã™ã€‚ Debianã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †ã¯ã€Debianç·¨ã€‘ã‚’ã”è¦§ãã ã•ã„ã€‚ Fedora CORE 4ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Fedora PROJECTã‚ˆã‚ŠFedora CORE 4ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ è©³ç´°ãªæ‰‹é †ã¯å‰²æ„›ã—ã¾ã™ãŒã€ä»¥é™ã¯ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®ç¨®é¡ž ã‚«ã‚¹ã‚¿ãƒ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚°ãƒ«ãƒ¼ãƒ—ã®é¸æŠž æœ€å°
hiroto-k 2006/11/20
oracle

db

linux
ãƒªãƒ³ã‚¯
1