[B! sql] ablaboã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ablabo id:ablabo

sqlã«é–¢ã™ã‚‹ablaboã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

ä¾¿åˆ©ï¼VIM(GVIM 7.x)ã§SQLã‚’æ•´å½¢ã™ã‚‹ | Labs Zsrv Net
ä¾¿åˆ©ï¼VIM(GVIM 7.x)ã§SQLã‚’æ•´å½¢ã™ã‚‹ April 23rd, 2008 Posted in Linux Write comment ã¨ã„ã†ã“ã¨ã§ã€VIMã«Macroã¨ã„ã†ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒã‚ã‚‹ã®ã§ã€ãã‚Œã‚’ä½¿ã†ã€‚ VIMç”¨ã®Macroã¨ã„ã†ã®ã¯ã„ã£ã±ã„æ—¢ã«å‡ºå›žã£ã¦ã„ã¦ã€ä»Šå›žã¯ä»¥ä¸‹ã®ã‚‚ã®ã‚’ä½¿ã†ã€‚ SQLUtilities http://www.vim.org/scripts/script.php?script_id=492 ã¾ãšã¯ã€ä¸Šè¨˜ã®å ´æ‰€ã‹ã‚‰Macroã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’è§£å‡ã—ã€VIMã®HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªé…ä¸‹ã®ã€Œpluginã€ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é…ç½®ã™ã‚‹ã€‚ â€»è§£å‡ã™ã‚‹ã¨ã€pluginãƒ•ã‚©ãƒ«ãƒ€ã‚’å«ã‚€è¤‡æ•°ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒå‡ºæ¥ã‚‹ã¨æ€ã†ã®ã§ã€ ã€€å®Ÿéš›ã«ã¯HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªé…ä¸‹ã®ã€Œpluginã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ä¸Šã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª ã€€ã«ä¸¸ã”ã¨ã‚³ãƒ”ãƒ¼ã™ã‚Œã°è‰¯
ablabo 2011/12/06
vim

db

sql
ãƒªãƒ³ã‚¯
SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œèª¿æŸ»ã§EXPLAIN PLANã€SQLãƒˆãƒ¬ãƒ¼ã‚¹ã¯ï¼ˆã»ã¨ã‚“ã©ï¼‰ä½¿ã‚ãªã„ Â« WR blog
December 2014Â (1) February 2014Â (1) January 2014Â (1) September 2012Â (1) April 2012Â (1) March 2012Â (2) October 2011Â (1) June 2011Â (5) May 2011Â (1) April 2011Â (1) March 2011Â (1) February 2011Â (1) January 2011Â (1) December 2010Â (1) September 2009Â (1) April 2009Â (1) March 2009Â (1) January 2009Â (3) November 2008Â (2) October 2008Â (1) December 2005Â (2) October 2005Â (2) September 2005Â (2) August 2005Â (7)
ablabo 2011/05/15
sql

performance

db
ãƒªãƒ³ã‚¯
æ›´æ–°ï¼æŒ¿å…¥ï¼å‰Šé™¤ã®SQLã‚’é«˜é€ŸåŒ–ã™ã‚‹3ã¤ã®æŠ€ã¨ã¯ï¼Ÿ
æ›´æ–°ï¼æŒ¿å…¥ï¼å‰Šé™¤ã®SQLã‚’é«˜é€ŸåŒ–ã™ã‚‹3ã¤ã®æŠ€ã¨ã¯ï¼Ÿï¼šOracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¬›åº§ï¼ˆ12ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚èªè€…ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’åŸºæœ¬ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ é€£è¼‰ç›®æ¬¡ å‰å›žã¯ã€çµžè¾¼ã¿æ¡ä»¶ï¼ˆWHEREæ¡ä»¶ï¼‰ã®æœ‰ç„¡ã«ã‚ˆã‚‹çµåˆå‡¦ç†ã‚„ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ãªã©Oracleã®æ©Ÿèƒ½ã‚’åˆ©ç”¨ã—ãŸçµåˆå‡¦ç†ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ‰‹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€WHEREæ¡ä»¶ãŒãªã„DMLï¼ˆINSERTã€DELETEã€UPDATEï¼‰å‡¦ç†ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ‰‹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™
ablabo 2011/02/18
mergeæ–‡ã€ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚¤ãƒ³ã‚µãƒ¼ãƒˆã€ãƒ‘ãƒ©ãƒ¬ãƒ«DMLã‚’ç”¨ã„ãŸå‡¦ç†é«˜é€ŸåŒ–ã«ã¤ã„ã¦

db

sql

oracle
ãƒªãƒ³ã‚¯
OTN Japan - 404 Error
ablabo 2010/09/15
"select to_char(clob_column) from hogehoge"ã§è¡¨ç¤ºå¯èƒ½

oracle

db

sql
ãƒªãƒ³ã‚¯
suVeneã®ã‚ã‚Œ: ä¿ºçš„ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ« SQLç·¨
2007å¹´01æœˆ19æ—¥ ä¿ºçš„ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ« SQLç·¨ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ«ãŒã“ã†ã§ãªã‘ã‚Œã°ã„ã‘ãªã„ã¨ã‹ã€ä»–äººã«å¼·åˆ¶ã™ã‚‹ã‚ã‘ã§ã¯ãªã„ãŒã€è‡ªåˆ†è‡ªèº«ã§ä¸€è²«æ€§ã®ç„¡ã„ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã¯æ°—æŒã¡æ‚ªã„ã®ã§ã€ã‚ªãƒ¬ã‚ªãƒ¬ãƒ«ãƒ¼ãƒ«ã‚’æ±ºã‚ã¦ãŸã‚Šã™ã‚‹ã€‚å¤§æŠµã¯ ãƒ‡ãƒ»ãƒ•ã‚¡ã‚¯ãƒˆçš„ãªãƒ«ãƒ¼ãƒ«ã«æ²¿ã†å½¢ã§æ›¸ãã“ã¨ãŒå¤šã„ã®ã ãŒã€SQL ã‚„ PL/SQL ã«é–¢ã—ã¦ã¯ãªã‹ãªã‹ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã¨å‘¼ã¹ã‚‹ã‚‚ã®ãŒãªã„ã®ã§(ã‚ã‚‹ã®ã‹?)ã€ãƒ¡ãƒ¢çš„ã«æ›¸ãã¨ã‚ã¦ãŠãã€‚ åŽŸå‰‡ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å°æ–‡å—ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåå¤§æ–‡å—ã‚«ãƒ³ãƒžã¯å¾Œã‚ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã¯åŠè§’ã‚¹ãƒšãƒ¼ã‚¹ã§ 2ä¸€ã¤ã® SQL æ–‡ã§ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰æ¯Žã«ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã—ãªã„(å‰¯å•åˆã›é™¤ã) ã¾ãšã€1.2. ã«ä»˜ã„ã¦ãªã®ã ãŒã€æ˜”ã¯ã€Œã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ï¼å¤§æ–‡å—ã€ã¨ã„ã†æ„å‘³ä¸æ˜Žãªå…ˆå…¥è¦³ã§å¤§æ–‡å—ã§æ›¸ã„ã¦ã„ãŸã€‚ãŸã ã€ãã‚Œã ã¨ PL/SQL ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚‚å¤§æ–‡å—ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåã‚‚å¤§æ–‡å—ã§çµå±€ã»ã¨ã‚“ã©å¤§æ–‡å—ã«ãªã£ã¦ã—ã¾ã†ã®ã¨ã€Shift æŠ¼ã™
ablabo 2007/01/21
DB

SQL
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

sqlã«é–¢ã™ã‚‹ablaboã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

sqlã«é–¢ã™ã‚‹ablaboã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ä¾¿åˆ©ï¼VIM(GVIM 7.x)ã§SQLã‚’æ•´å½¢ã™ã‚‹ | Labs Zsrv Net

SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œèª¿æŸ»ã§EXPLAIN PLANã€SQLãƒˆãƒ¬ãƒ¼ã‚¹ã¯ï¼ˆã»ã¨ã‚“ã©ï¼‰ä½¿ã‚ãªã„ Â« WR blog

æ›´æ–°ï¼æŒ¿å…¥ï¼å‰Šé™¤ã®SQLã‚’é«˜é€ŸåŒ–ã™ã‚‹3ã¤ã®æŠ€ã¨ã¯ï¼Ÿ

OTN Japan - 404 Error

suVeneã®ã‚ã‚Œ: ä¿ºçš„ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ« SQLç·¨

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

sqlã«é–¢ã™ã‚‹ablaboã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ä¾¿åˆ©ï¼VIM(GVIM 7.x)ã§SQLã‚’æ•´å½¢ã™ã‚‹ | Labs Zsrv Net

SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œèª¿æŸ»ã§EXPLAIN PLANã€SQLãƒˆãƒ¬ãƒ¼ã‚¹ã¯ï¼ˆã»ã¨ã‚“ã©ï¼‰ä½¿ã‚ãªã„ Â« WR blog

æ›´æ–°ï¼æŒ¿å…¥ï¼å‰Šé™¤ã®SQLã‚’é«˜é€ŸåŒ–ã™ã‚‹3ã¤ã®æŠ€ã¨ã¯ï¼Ÿ

suVeneã®ã‚ã‚Œ: ä¿ºçš„ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ« SQLç·¨

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹