[B! ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°][sql] Itisangoã®ãƒ

Itisango id:Itisango

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¨sqlã«é–¢ã™ã‚‹Itisangoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (33)

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

Goã¨Dependency Injectionã®ç¾åœ¨ï½œSeiji Takahashi@ãƒ™ãƒ¼ã‚¹ãƒžã‚ãƒŠ
tl;drãƒ»Goã®ä¾å˜æ€§æ³¨å…¥ã¯æ™®é€šã«è¡Œã‚ã‚Œã‚‹ãŒã€DIãƒ„ãƒ¼ãƒ«ã¯ã¾ã è¦³æ¸¬ç¯„å›²ã§ã¯æµ¸é€ã—ã¦ã„ãªã„ã€‚ ãƒ»ç›´è¿‘å‡ºãŸGoogleè£½Goå‘ã‘DIãƒ„ãƒ¼ãƒ«ã€ŒWireã€ã¯ã‚·ãƒ³ãƒ—ãƒ«ãªAPIã‚„ãƒ„ãƒ¼ãƒ«ä½œæˆã§æœ‰ç”¨ã ãŒã€ä¾å˜ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®è¨å®šãŒè¤‡é›‘åŒ–ã™ã‚‹ã¨è¡¨ç¾æ€§ã«é™ç•ŒãŒãã‚‹ ãƒ»Goã«ãŠã„ã¦ã€DIãƒ„ãƒ¼ãƒ«ã¯ã‚ã‚‹ç¨®ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¨èªè˜ã—ã¦æ…Žé‡ã«æŽ¡ç”¨ã™ã¹ãå‰æï¼šGoã®ä¾å˜æ€§æ³¨å…¥ã¨èª²é¡ŒGoã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãéš›ã€ç‰¹ã«ä¸€å®šè¦æ¨¡ã‚’è¶…ãˆãŸAPIã‚’æ›¸ãéš›ã¯ã€ä¾å˜ã™ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã„ã†ã®ãŒå¢—ãˆã‚‹ã€‚DBã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚„ãƒã‚¬ãƒ¼ã‚„å„ç¨®ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã‚’å‘¼ã³å‡ºã™ã‚µãƒ¼ãƒ“ã‚¹å±¤ãªã©ãŒãã‚Œã«è©²å½“ã™ã‚‹ã€‚ ãƒ¬ã‚¤ãƒ¤ãƒ¼åŒ–ã•ã‚ŒãŸãƒ‘ãƒƒã‚±ãƒ¼ã‚¸æ§‹æˆã®ä¸‹ã€ã“ã†ã—ãŸä¾å˜ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ãƒˆãƒƒãƒ—ãƒ€ã‚¦ãƒ³ã«æ³¨å…¥ã—ã¦ã„ãã‚„ã‚Šæ–¹ã¯è¦‹é€šã—ãŒã‚ˆãã€ãƒ†ã‚¹ãƒˆæ™‚ã«ãƒ¢ãƒƒã‚¯ã®APIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’å·®ã—è¾¼ã¿ã‚„ã™ã‹ã£ãŸã‚Šã¨ã€ãƒ†ã‚¹ã‚¿ãƒ“ãƒªãƒ†ã‚£ã‚’å‘ä¸Šã•ã›ã‚‹ã€‚ã–ã£ãã‚Šä¾å˜æ€§æ³¨å…¥ãŒè¡Œã‚ã‚Œã‚‹ã‚ˆã†ãªãƒ¬ã‚¤ãƒ¤ãƒ¼åŒ–ã•ã‚ŒãŸæ§‹æˆã§ã€ãªã‚“
Itisango 2019/02/13
SQL

db

github

golang

ã‚ã¨ã§èªã‚€

programming

software

development

Google

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
Accessã§ãƒ†ãƒ¼ãƒ–ãƒ«åã‚„ã‚¯ã‚¨ãƒªåä¸€è¦§ã®æŠœãå‡ºã—
ãƒ»ã‚¯ã‚¨ãƒªã‚’æ–°è¦ä½œæˆ ãƒ»ä»¥ä¸‹SQLã‚’è²¼ã‚Šä»˜ã‘ SELECT MSysObjects.Type, MSysObjects.Name, MSysObjects.Flags FROM MSysObjects ORDER BY MSysObjects.Type, MSysObjects.Name; ãƒ»ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ“ãƒ¥ãƒ¼ã§è¡¨ç¤º ã‚ã¨ã¯ã€Typeã¨Flagsã®æ¡ä»¶ã‚’å¤‰ãˆã¦ã‚ã’ã‚Œã°ä¸€è¦§ã§ãã¾ã™ã€‚ ã“ã®å›žç”ã¸ã®è£œè¶³ æœ€è¿‘ï¼°ï¼£ã‚’ã¡ã‚‡ã£ã¨ä½¿ãˆãšã€ã€ãŠç¤¼ãŒé…ããªã‚Šã¾ã—ã¦å¤§å¤‰ã™ã¿ã¾ã›ã‚“<m(__)m><m(__)m>ã€€ãã—ã¦ã€å›žç”ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ï¼ ã™ã”ã„ã§ã™ãï¼ã“ã‚“ãªæ©Ÿèƒ½ï¼Ÿï¼ãŒã‚ã‚‹ã‚“ã§ã™ãã€‚ ãŸã ã€ã€Typeã‚„Flagsã®ã‚³ãƒ¼ãƒ‰(?)ã«æ„å‘³ãŒã‚ã‚‹ã¨æ€ã†ã®ã§ã™ãŒã€ã€ãã®ä¸€è¦§è¡¨ã¿ãŸã„ã®ã¯ã€ã©ã“ã‹ã«ã®ã£ã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼ŸHelpã‚’è¦‹ãŸã®ã§ã™ãŒãã“ã«ã¯è¼‰ã£ã¦ã„ãªã„ã‚ˆã†ã§ã—ãŸã®ã§ã€‚ ã‚³ãƒ¼ãƒ‰ã®æ„å‘³ãŒè¼‰ã£ã¦ã„ã‚‹æ‰€ã‚‚ã—ãã¯ã€
Itisango 2018/12/12
SQL

access

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

é–‹ç™º

Microsoft

Windows
ãƒªãƒ³ã‚¯
Accessã§SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã™ã‚‹æ–¹æ³• | ã‚¢ã‚¤ãƒ“ãƒ¼ã‚¹ã‚¿ãƒ¼
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ã„ã‚ã„ã‚ãªå‡¦ç†ãŒé…ããªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ãã®å¯¾ç–ã¨ã—ã¦SQLã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã§ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã„ã¾ã™ã€‚ Accessã‚‚ä¾‹å¤–ã§ã¯ãªãã€å…ˆæ—¥ã€100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‡¦ç†ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œã£ãŸã¨ãã¯ã€ã‚ã‚Œã‚„ã“ã‚Œã‚„ã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ã¦å‡¦ç†ã‚’é€Ÿã‚ã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸã€‚ ãã®æ™‚ã«çŸ¥ã£ãŸã®ã§ã™ãŒã€Accessã§SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ã€ãã‚Œã‚’å‚è€ƒã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ä¸‹è¨˜ã«ãã®Accessã«ã‚ˆã‚‹å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚’ãƒ¡ãƒ¢ä»£ã‚ã‚Šã«æ˜Žè¨˜ã—ã¦ãŠãã¾ã™ã€‚ Accessã§SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã™ã‚‹ã«ã¯Windowsã®ãƒ¬ã‚¸ã‚¹ãƒˆãƒªã‚’è§¦ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãƒ¬ã‚¸ã‚¹ãƒˆãƒªã¯å¾¡å˜çŸ¥ã®é€šã‚Šã€Windowsã‚’å‹•ã‹ã™ä¸Šã§é‡è¦ãªéƒ¨åˆ†ã§ã™ã€‚ãƒ˜ã‚¿ã«è§¦ã£ã¦å£Šã—ã¦ã—ã¾ã†ã¨WindowsãŒå£Šã‚Œã€æœ€æ‚ªã®å ´åˆã€WindowsãŒäºŒåº¦ã¨å‹•ã‹ãªããªã‚‹å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚ãã®ç‚ºã€ä¸‹è¨˜æ–¹æ³•ã‚’è¡Œã†å ´åˆã¯è‡ªå·±è²¬ä»»ã§è¡Œã£ã¦ãã ã•ã„
Itisango 2018/11/28
SQL

windows

database

ç’°å¢ƒ

programming

development

software

é–‹ç™º

ä»•äº‹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
AccessVBAå¾¹åº•å…¥é–€ Chapter5-8 ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œ | T'sWare
è¿½åŠ ã‚¯ã‚¨ãƒªãƒ»æ›´æ–°ã‚¯ã‚¨ãƒªãƒ»å‰Šé™¤ã‚¯ã‚¨ãƒªã¨ã„ã£ãŸã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¨ãƒªã‚’VBAã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ã«ã‚ˆã£ã¦å‡¦ç†æ–¹æ³•ã‚’ä½¿ã„åˆ†ã‘ã¾ã™ã€‚ ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¨ãƒªãŒâ€ã‚¯ã‚¨ãƒªâ€ã¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹å ´åˆ SQLæ–‡ã‚’VBAã§å‹•çš„ã«çµ„ã¿ç«‹ã¦ã¦å‡¦ç†ã™ã‚‹å ´åˆ â– DoCmdã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®OpenQueryãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã£ãŸæ–¹æ³• â€»ã“ã®æ–¹æ³•ã¯ã€ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¨ãƒªãŒâ€ã‚¯ã‚¨ãƒªâ€ã¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹å ´åˆã«ä½¿ã„ã¾ã™ã€‚ â€»SetWarningsã‚’Falseã¨ã™ã‚‹ã“ã¨ã§ã€ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¨ãƒªå®Ÿè¡Œå‰ã®ç¢ºèªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã•ã›ãšã«ã€ãã®ã¾ã¾å³å®Ÿè¡Œã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ â– SQLæ–‡ã§æŒ‡å®šã™ã‚‹å ´åˆï¼ˆDatabaseã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ã€ŒExecuteã€ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ç”¨ï¼‰ DimÂ dbsÂ AsÂ Database DimÂ strRateÂ AsÂ String DimÂ strSQLÂ AsÂ String Beep strRateÂ
Itisango 2018/10/04
SQL

ado

access

programming

software

development

Microsoft

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º

ä»•äº‹
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Itisango 2018/10/03
access

VBA

SQL

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

æ¤œç´¢

programming

software

development

Microsoft

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
Oracleã‹ã‚‰ã®CSVå‡ºåŠ›ã‚’è€ƒãˆã‚‹ - kagamihogeã®æ—¥è¨˜
è»½ãããã£ãŸã ã‘ãªã®ã§é–“é•ã£ã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ãŒã€Oracleã«ã¯CSVå‡ºåŠ›ã®æ©Ÿèƒ½ãªã‚ŠAPIãªã‚Šã¯å‚™ã‚ã£ã¦ã„ãªã„ã€‚ãŸã ã—ã€SQL*Plusã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚ã‚‹ã¨ã‹PL/SQLã‚’ä½¿ã†ã¨ã‹ã§CSVå‡ºåŠ›ã¯å®Ÿç¾å‡ºæ¥ã‚‹ã€‚ä»Šå›žã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€è‡ªåˆ†ãŒèª¿ã¹ã‚‰ã‚ŒãŸç¯„å›²å†…ã§CSVå‡ºåŠ›ã®æ–¹æ³•ã‚’è‰²ã€…è©¦ã—ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ è©¦ã™æ–¹æ³•ã®è¦ç´„ã¯ä¸‹è¨˜ã®é€šã‚Šã€‚ PL/SQLã§UTL_FILEã‚’ä½¿ç”¨ã—ã¦CSVå‡ºåŠ›ï¼ˆãƒã‚¤ãƒ†ã‚£ãƒ–ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æœ‰åŠ¹ï¼‰ Oracleã¨ã¯åˆ¥ãƒžã‚·ãƒ³ã‹ã‚‰ã€JDBDçµŒç”±ã§CSVå‡ºåŠ› Oracleã¨ã¯åˆ¥ãƒžã‚·ãƒ³ã‹ã‚‰ã€SQL*Plusã§SPOOLã‚’ä½¿ç”¨ã—ã¦CSVå‡ºåŠ› Oracleã¨ã¯åˆ¥ãƒžã‚·ãƒ³ã‹ã‚‰ã€SQL Developerã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆæ©Ÿèƒ½ã‚’ä½¿ç”¨ã—ã¦CSVå‡ºåŠ› ä»¥ä¸‹ã§ã¯ã€è¨ˆæ¸¬å¯¾è±¡ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã«ç¶šãã€ãã‚Œãžã‚Œã®æ–¹æ³•ã®ãƒ—ãƒã‚°ãƒ©ãƒ ç‰ã‚’ç¤ºã™ã€‚ãã®ã‚ã¨ã€å®Ÿè¡Œæ™‚é–“ã®æ¯”è¼ƒã¨æ„Ÿæƒ³ã‚’è¿°ã¹ã‚‹ã€‚ ç’°å¢ƒ DB CentOS-6.4-x86_64
Itisango 2018/09/19
oracle

SQL

java

csv

file

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
Oracle Databaseã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’CSVå‡ºåŠ›ã™ã‚‹6ã¤ã®æ–¹æ³•
æœ¬è¨˜äº‹ã¯ JPOUG Advent Calendar 2017 ã®ï¼‘æ—¥ç›®ã§ã™ã€‚ Oracle Database ã§ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤–éƒ¨ã«å‡ºåŠ›ã™ã‚‹ã«ã¯ Data Pump ã‚’ä½¿ã†ã“ã¨ãŒä¸€èˆ¬çš„ã§ã™ãŒã€å¤–éƒ¨ã‚·ã‚¹ãƒ†ãƒ ã¨ãƒ‡ãƒ¼ã‚¿é€£ä¿‚ã™ã‚‹å ´åˆã«ã¯ CSV å½¢å¼ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§è¡Œã†ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ãã“ã§ 2017 å¹´ç¾åœ¨ã ã£ãŸã‚‰ CSV å½¢å¼ã®å‡ºåŠ›ã«ã©ã®ã‚ˆã†ãªæ–¹æ³•ãŒã‚ã‚‹ã®ã‹è©¦ã—ãŸã¨ãã®ãƒ¡ãƒ¢ã«ãªã‚Šã¾ã™ã€‚ ç’°å¢ƒ ä»Šå›žã¯ Oracle Database 12.1.0.2 ã®ãƒ—ãƒ©ã‚¬ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆPDBï¼‰ã® SCOTT ã‚¹ã‚ãƒ¼ãƒžã® EMP ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹å ´åˆã‚’æƒ³å®šã—ã¾ã™ã€‚ ã‚¹ã‚ãƒ¼ãƒžã¯ Database ä»˜å±žã®ã‚µãƒ³ãƒ—ãƒ«ã‚¹ã‚ãƒ¼ãƒžä½œæˆã‚¹ã‚¯ãƒªãƒ—ãƒˆï¼ˆutlsampl.sqlï¼‰ã§ä½œæˆã—ã¾ã™ã€‚ $ export TWO_TASK=localhost/pdb $ sqlplus system '@?/rdb
Itisango 2018/09/19
oracle

SQL

database

it

csv

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

IT
ãƒªãƒ³ã‚¯
JDBCãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ ãƒ¡ãƒ¢(Hishidama's JDBC DatabaseMetaData/ResultSetMetaData Memo)
JDBCã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBï¼‰ã®ï¼ˆãƒ‡ãƒ¼ã‚¿ã§ãªãï¼‰å®šç¾©è‡ªä½“ã‚’æ‰±ã†ã€‚ ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’åˆ©ç”¨ã—ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®é …ç›®ä¸€è¦§ã ã¨ã‹å±žæ€§ã ã¨ã‹ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚‹ã€‚ DatabaseMetaDataã¯Connectionã‹ã‚‰å–å¾—ã§ãã‚‹ã€‚ ResultSetMetaDataã¯ResultSetã‹ã‚‰å–å¾—ã§ãã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®é …ç›®ä¸€è¦§ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼é …ç›® ãƒ¬ã‚³ãƒ¼ãƒ‰ä¸€æ„è˜åˆ¥é …ç›® é …ç›®ã®åž‹ã®å–å¾— [2009-04-10] PreparedStatementã®é …ç›®ã®åž‹ [2009-10-25] è‡ªå‹•æŽ¡ç•ªå€¤ã®å–å¾— [/2010-07-24] ãƒ†ãƒ¼ãƒ–ãƒ«ã®é …ç›®ä¸€è¦§ã‚’å–å¾—ã™ã‚‹ä¾‹ import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.ResultSet; Connection conn = ï½ž; DatabaseM
Itisango 2018/09/18
java

jdbc

db

oracle

SQL

software

programming

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
SQL*Loaderãƒ¡ãƒ¢(Hishidama's sqlloader for Oracle9i Memo)
CSVãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰Oracleã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ãƒ‡ãƒ¼ã‚¿ã‚’æµã—è¾¼ã‚€ãƒ„ãƒ¼ãƒ«ã€‚ å¤§é‡ã®insertæ–‡ã‚’ç™ºè¡Œã™ã‚‹ã‚ˆã‚Šã¯ã€æ–ç„¶é«˜é€Ÿã€‚ ãƒ‡ãƒ¼ã‚¿ã§ã‚ã‚‹CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚„å›ºå®šé•·ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã€ãƒãƒ¼ãƒ‰æ–¹æ³•ã‚’æŒ‡å®šã™ã‚‹ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”¨æ„ ã—ã¦å®Ÿè¡Œã™ã‚‹ã€‚ ï¼ˆCSVãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã®ãƒãƒ¼ãƒ‰ã¯ã“ã®SQL*LoaderãŒä½¿ãˆã‚‹ãŒã€CSVå‡ºåŠ›ã«ã¯æ¨™æº–çš„ãªæ–¹æ³•ã¯ç„¡ã„ã‚‰ã—ãã¦ã€selectæ–‡ã§åŠ å·¥ã™ã‚‹æ–¹æ³•ãŒã‚ˆãä½¿ã‚ã‚Œã‚‹ã‚‰ã—ã„ã€‚ ã“ã®SQLæ–‡ã‚’ã„ã¡ã„ã¡æ›¸ãã®ã¯å°‘ã€…é¢å€’ãªã®ã§ã€SQLç”Ÿæˆç”¨Excelãƒžã‚¯ãƒã‚’ä½œã£ã¦ã¿ã¾ã—ãŸï¼‰ ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ•ã‚¡ã‚¤ãƒ« CSVãƒ•ã‚¡ã‚¤ãƒ«ã®å„é …ç›®ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®é …ç›®ã¨ã®é–¢é€£ä»˜ã‘ç‰ã‚’æŒ‡å®šã™ã‚‹ã€‚ ï¼ˆã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§æ›¸ãã®ã¯ã‘ã£ã“ã†é¢å€’ãªã®ã§ã€ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ä½œæˆç”¨Excelãƒžã‚¯ãƒã‚’ä½œã£ã¦ã¿ã¾ã—ãŸï¼ˆCSVãƒ•ã‚¡ã‚¤ãƒ«ç”¨ã€å›ºå®šé•·ãƒ•ã‚¡ã‚¤ãƒ«ç”¨ï¼‰ï¼‰ ä¾‹ï¼‰emp.ctlï¼š OPTIONS(LOAD=100,SK
Itisango 2018/09/13
SQL

oracle

Excel

sql*loader

db

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
è‡ªå·±çµåˆã®ä½¿ã„æ–¹
ã¯ã˜ã‚ã« SQLãŒæä¾›ã™ã‚‹çµåˆæ¼”ç®—ã«ã¯ã€ãã®ç‰¹å¾´ã«å¿œã˜ã¦å†…éƒ¨çµåˆã€å¤–éƒ¨çµåˆã€ã‚¯ãƒã‚¹çµåˆãªã©ã•ã¾ã–ã¾ãªåå‰ãŒä¸Žãˆã‚‰ã‚Œã¦ã„ã¾ã™ã€‚æ™®é€šã€ã“ã‚Œã‚‰ã®çµåˆã®å¤šãã¯ã€ç•°ãªã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ãŸã¯ãƒ“ãƒ¥ãƒ¼ã‚’å¯¾è±¡ã¨ã—ã¦è¡Œã‚ã‚Œã¾ã™ã€‚ã—ã‹ã—ã€SQLã¯çµåˆãŒåŒä¸€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ãŸã¯ãƒ“ãƒ¥ãƒ¼ã«é©ç”¨ã•ã‚Œã‚‹ã“ã¨ã‚’ç¦æ¢ã—ã¦ã„ã¾ã›ã‚“ã€‚åŒä¸€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å¯¾è±¡ã«è¡Œã†çµåˆã‚’ã€Œè‡ªå·±çµåˆï¼ˆself joinï¼‰ã€ã¨å‘¼ã³ã¾ã™ã€‚è‡ªå·±çµåˆã¯ã€ä½¿ã„ã“ãªã›ã°éžå¸¸ã«ä¾¿åˆ©ãªæŠ€è¡“ã§ã™ãŒã€å‹•ä½œãŒã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã«ãã„ãŸã‚æ•¬é ã•ã‚ŒãŒã¡ã§ã™ã€‚ãã“ã§æœ¬ç¨¿ã§ã¯ã€ã“ã®è‡ªå·±çµåˆã®ä¾¿åˆ©ã•ã‚’ä¾‹é¡Œã‚’é€šã—ã¦å¦ã³ã€ãã®å‹•ä½œã‚’åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¾ã™ã€‚ è‡ªå·±çµåˆã‚’ç†è§£ã™ã‚‹ã“ã¨ã¯ã€å®Ÿå‹™ä¸Šã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’èº«ã«ã¤ã‘ã‚‹ä»¥å¤–ã«ã€ã‚‚ã†ä¸€ã¤åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ãã‚Œã¯ã€é›†åˆæŒ‡å‘ï¼ˆset-orientedï¼‰ã¨ã„ã†SQLã®é‡è¦ãªç‰¹å¾´ã‚’ç†è§£ã§ãã‚‹ã“ã¨ã§ã™ã€‚ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘è¨€èªžãŒä¸–ç•Œã‚’ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦è¡¨ç¾ã™ã‚‹ã‚ˆã†ã«ã€SQLã¯ä¸–ç•Œ
Itisango 2018/09/13
æŠ€è¡“

SQL

ä¾¿åˆ©

SQL - é›†åˆè‡ªå·±çµåˆ

software

development

programming

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢
ãƒªãƒ³ã‚¯
JDBCã®æ¦‚è¦
1 JDBCã®æ¦‚è¦ ã“ã®ç« ã§ã¯ã€Java Database Connectivityï¼ˆJDBCï¼‰ã®Oracleå®Ÿè£…ã®æ¦‚è¦ã‚’èª¬æ˜Žã—ã¾ã™ã€‚æ¬¡ã®é …ç›®ãŒå«ã¾ã‚Œã¾ã™ã€‚ JDBCã®æ¦‚è¦ Oracle JDBCãƒ‰ãƒ©ã‚¤ãƒã®æ¦‚è¦ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŠã‚ˆã³ã‚¢ãƒ—ãƒ¬ãƒƒãƒˆæ©Ÿèƒ½ã®æ¦‚è¦ ã‚µãƒ¼ãƒãƒ¼å´ã®åŸºæœ¬ ç’°å¢ƒãŠã‚ˆã³ã‚µãƒãƒ¼ãƒˆ ã“ã®ãƒªãƒªãƒ¼ã‚¹ã®å¤‰æ›´ç‚¹ JDBCã®æ¦‚è¦ JDBCã¯ã€Javaã‹ã‚‰ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚’æä¾›ã™ã‚‹Javaæ¨™æº–ã§ã™ã€‚JDBCæ¨™æº–ã¯Sunç¤¾ã«ã‚ˆã£ã¦å®šç¾©ã•ã‚Œã€æ¨™æº–ã®java.sqlã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚’ä»‹ã—ã¦å®Ÿè£…ã•ã‚Œã¾ã™ã€‚ã“ã®ãŸã‚ã€å„ãƒ—ãƒãƒã‚¤ãƒ€ã¯ç‹¬è‡ªã®JDBCãƒ‰ãƒ©ã‚¤ãƒã§æ¨™æº–ã‚’å®Ÿè£…ãŠã‚ˆã³æ‹¡å¼µã§ãã¾ã™ã€‚ JDBCã¯ã€X/Open SQLã‚³ãƒ¼ãƒ«ãƒ»ãƒ¬ãƒ™ãƒ«ãƒ»ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ï¼ˆCLIï¼‰ã«åŸºã¥ãã€SQL92ã‚¨ãƒ³ãƒˆãƒªãƒ»ãƒ¬ãƒ™ãƒ«æ¨™æº–ã«æº–æ‹ ã—ã¦ã„ã¾ã™ã€‚ Oracle JDBCãƒ‰ãƒ©ã‚¤ãƒã®æ¦‚è¦ Oracl
Itisango 2018/09/12
oracle

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

ã‚µãƒ¼ãƒ

SQL

java

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
SQL*Loaderã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
7 SQL*Loaderã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ ã“ã®ç« ã§ã¯ã€SQL*Loaderã‚’èµ·å‹•ã™ã‚‹ãŸã‚ã«ä½¿ç”¨ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ç« ã®å†…å®¹ã¯ã€æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ SQL*Loaderã®èµ·å‹• ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ çµ‚äº†ã‚³ãƒ¼ãƒ‰ã«ã‚ˆã‚‹çµæžœã®æ¤œæŸ»ã¨è¡¨ç¤º SQL*Loaderã®èµ·å‹• SQL*Loaderã‚’èµ·å‹•ã™ã‚‹ã¨ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ç‰¹æ€§ã‚’ç¢ºç«‹ã™ã‚‹ãŸã‚ã«ç‰¹å®šã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æŒ‡å®šã§ãã¾ã™ã€‚ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ä»»æ„ã®é †åºã§å…¥åŠ›ã§ãã¾ã™ã€‚ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¨ã—ã¦ã€ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«å€¤ã‚’æŒ‡å®šã™ã‚‹ã‹ã€å ´åˆã«ã‚ˆã£ã¦ã¯ã€å€¤ã‚’å…¥åŠ›ã—ãªã„ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚’æŒ‡å®šã§ãã¾ã™ã€‚ æ¬¡ã«ä¾‹ã‚’ç¤ºã—ã¾ã™ã€‚ SQLLDR CONTROL=sample.ctl, LOG=sample.log, BAD=baz.bad, DATA=etc.dat USERID=scott/tiger, ERRORS=999,
Itisango 2018/09/12
SQL

oracle

SQL*Loader

file

ã‚³ãƒžãƒ³ãƒ‰

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
PL/SQL - Wikipedia
PL/SQLï¼ˆãƒ”ãƒ¼ã‚¨ãƒ«ãƒ»ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã¯ã€Oracleç¤¾ãŒã€Oracle Databaseã®ãŸã‚ã«ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨€èªžSQLã‚’ç‹¬è‡ªã«æ‹¡å¼µã—ãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã€Adaè¨€èªžã‚’å‚è€ƒã«ã—ã¦é–‹ç™ºã•ã‚ŒãŸè¨€èªžã§ã‚ã‚‹ã€‚PL/SQLã¯1988å¹´ã«Oracle Databaseã«å¯¾ã—ã¦åˆã‚ã¦è¿½åŠ ã•ã‚ŒãŸã€‚ ã‚‚ã¨ã‚‚ã¨éžæ‰‹ç¶šãåž‹è¨€èªžã§ã‚ã‚‹SQLã‚’æ‰‹ç¶šãåž‹è¨€èªžï¼ˆProcedural Languageï¼‰ã«æ‹¡å¼µã™ã‚‹ã¨ã“ã‚ã‹ã‚‰ã€ŒPL/SQLã€ã¨å‘½åã•ã‚ŒãŸçµŒç·¯ã‚’æŒã¤ã€‚PL/SQLã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€æ‰‹ç¶šãåž‹è¨€èªžã§åŸ‹ã‚è¾¼ã¿SQLã«ã‚ˆã‚‹å‡¦ç†ã¨åŒæ§˜ã«ã€å¤‰æ•°ã®åˆ©ç”¨ã‚„if / for / loopãªã©ã®åˆ¶å¾¡æ§‹é€ ã‚’è¨˜è¿°ã—ã¦ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ï¼ˆBusiness Logicï¼‰ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã«å®Ÿè£…ã™ã‚‹ã“ã¨ãŒã§ãã€å•ã„åˆã‚ã›çµæžœã®è¡Œã‚’1ä»¶ãšã¤å‡¦ç†ã™ã‚‹å ´åˆã«ã¯ã€ã‚«ãƒ¼ã‚½ãƒ«ã«ã‚ˆã‚‹FETCHãƒ«ãƒ¼ãƒ—ã§ã®å‡¦ç†ã‚’è¡Œã†ã“ã¨ãŒå‡ºæ¥ã‚‹ã€‚æ•°å€¤è¨ˆç®—ã®åŠ¹çŽ‡åŒ–ã®
Itisango 2018/09/12
SQL

DBMS

oracle

wikipedia

è¨€èªž

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
ã€Oracleã€‘ã‚«ãƒ©ãƒ ï¼ˆåˆ—ï¼‰ã®ä¸€è¦§ã‚’ç¢ºèªã™ã‚‹SQL
Oracleã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ (åˆ—)ã®ä¸€è¦§ã‚’ç¢ºèªã™ã‚‹ALL_TAB_COLUMNS å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ ã®ä¸€è¦§ã‚’ç¢ºèªã™ã‚‹SQL -- å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ (åˆ—)ã®ä¸€è¦§ã‚’å‚ç…§ SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'satou'; Oracleã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã®ã‚«ãƒ©ãƒ (åˆ—)ã‚’SQLã§å‚ç…§ã§ãã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ (åˆ—)ã‚’ä¸€è¦§ã§ç¢ºèªã™ã‚‹ã«ã¯ã€ŒALL_TAB_COLUMNSã€ã‚’ä½¿ã„ã¾ã™ã€‚ ã“ã“ã§ã¯å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ãŒç¢ºèªã§ãã¾ã—ãŸã€‚ ã‚«ãƒ©ãƒ ã®ä¸€è¦§ã‚’ç¢ºèªã™ã‚‹SQL ä¸Šã®ä¾‹ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ãŒå¤šã„ã¨ä¸€è¦§ã§ç¢ºèªã™ã‚‹ã®ãŒå¤§å¤‰ã§ã™ã€‚ã‚‚ã†å°‘ã—å…·ä½“çš„ã«ä½¿ãˆã‚‹SQLã«æ”¹å–„ã—ãŸSQLã«ã—ã¦ã¿ã¾ã™ã€‚ -- empã®ã‚«ãƒ©ãƒ (åˆ—)ã®ä¸€è¦§ã‚’å‚ç…§ SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DAT
Itisango 2018/09/11
oracle

SQL

ALL_TAB_COLUMNS

programming

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

software

development

é–‹ç™º
ãƒªãƒ³ã‚¯
SQL ã§ç¸¦æ¨ªå¤‰æ›ã¾ã¨ã‚ï¼ˆpivot ã¨ unpivotï¼‰ - Qiita
ä¸‹å›³ã®ã‚ˆã†ã«ã€ã€Œç¸¦æŒã¡ã€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã€Œæ¨ªæŒã¡ã€ã«ç½®ãæ›ãˆã‚‹ã“ã¨ã‚’ãƒ”ãƒœãƒƒãƒˆï¼ˆpivotï¼‰ã€é€†ã«ã€Œæ¨ªæŒã¡ã€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã€Œç¸¦æŒã¡ã€ã«ç½®ãæ›ãˆã‚‹ã“ã¨ã‚’ã‚¢ãƒ³ãƒ”ãƒœãƒƒãƒˆï¼ˆunpivotï¼‰ã¨å‘¼ã³ã¾ã™ã€‚ã“ã‚Œã‚‰ã®å¤‰æ›ã‚’è¡Œãªã†æ–¹æ³•ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ æ¨™æº–SQL Presto Hive Pandas (Python) æ¨™æº–SQL SQL-like ãªã‚¯ã‚¨ãƒªè¨€èªžãªã‚‰ã©ã“ã§ã‚‚ä½¿ãˆã‚‹æ›¸ãæ–¹ã§ã™ã€‚ Pivot SELECT uid, max(CASE WHEN key = 'c1' THEN value END) AS c1, max(CASE WHEN key = 'c2' THEN value END) AS c2, max(CASE WHEN key = 'c3' THEN value END) AS c3 FROM vtable GROUP BY uid ;
Itisango 2018/09/10
SQL

pivot

ç¸¦æŒã¡

programming

software

development

é–‹ç™º

ä»•äº‹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/sqlloadercsv
Itisango 2018/09/06
oracle

SQL

database

æŠ€è¡“

blog

programming

software

development

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
Itisango 2018/01/02
mysql

sql

DB

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

programming

software

development

science

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼šæƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼šè„†å¼±æ€§å¯¾ç–ï¼šå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹
ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã¯ã€IPAãŒå±Šå‡º(*1)ã‚’å—ã‘ãŸè„†å¼±æ€§é–¢é€£æƒ…å ±ã‚’åŸºã«ã€å±Šå‡ºä»¶æ•°ã®å¤šã‹ã£ãŸè„†å¼±æ€§ã‚„æ”»æ’ƒã«ã‚ˆã‚‹å½±éŸ¿åº¦ãŒå¤§ãã„è„†å¼±æ€§ã‚’å–ã‚Šä¸Šã’ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…ãŒé©åˆ‡ãªã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’è€ƒæ…®ã—ãŸã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ä½œæˆã™ã‚‹ãŸã‚ã®è³‡æ–™ã§ã™ã€‚ ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€æ”¹è¨‚ç¬¬7ç‰ˆã®å†…å®¹ ç¬¬1ç« ã§ã¯ã€ã€Œã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å®Ÿè£…ã€ã¨ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ã€OSã‚³ãƒžãƒ³ãƒ‰ãƒ»ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ã‚„ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆãƒ»ã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚° ç‰11ç¨®é¡žã®è„†å¼±æ€§ã‚’å–ã‚Šä¸Šã’ã€ãã‚Œãžã‚Œã®è„†å¼±æ€§ã§ç™ºç”Ÿã—ã†ã‚‹è„…å¨ã‚„ç‰¹ã«æ³¨æ„ãŒå¿…è¦ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ç‰¹å¾´ç‰ã‚’è§£èª¬ã—ã€è„†å¼±æ€§ã®åŽŸå› ãã®ã‚‚ã®ã‚’ãªãã™æ ¹æœ¬çš„ãªè§£æ±ºç–ã€æ”»æ’ƒã«ã‚ˆã‚‹å½±éŸ¿ã®ä½Žæ¸›ã‚’æœŸå¾…ã§ãã‚‹å¯¾ç–ã‚’ç¤ºã—ã¦ã„ã¾ã™ã€‚ ç¬¬2ç« ã§ã¯ã€ã€Œã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®å®‰å…¨æ€§å‘ä¸Šã®ãŸã‚ã®å–ã‚Šçµ„ã¿ã€ã¨ã—ã¦ã€ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã®é‹ç”¨ã«é–¢ã™ã‚‹å¯¾ç–ã‚„ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã«ãŠã‘ã‚‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å–æ‰±ã„ã«é–¢ã™
Itisango 2017/04/29
#IPA ã®è„†å¼±æ€§å¯¾ç–æƒ…å ±

ipa

web

security

Webåˆ¶ä½œ

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

information

SQL

2012å¹´

2006å¹´
ãƒªãƒ³ã‚¯
ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ä¸Šä½nä»¶ã‚’å–å¾—ã™ã‚‹SQL
ã¡ãªã¿ã«ã€PostgreSQL8ã§ç¢ºèªã—ã¾ã—ãŸãŒã€ä»–ã®RDBã§ã¯ç¢ºèªã—ã¦ã„ã¾ã›ã‚“ã€‚ã“ã®SQLã§ã¯åŒç‚¹ã®å ´åˆã«IDé †ã§ä¸Šä½ã‚’æ±ºã‚ã¦ã„ã¾ã™ã€‚åŒç‚¹ã¯å…¨ã¦å‡ºã™ã¨ã„ã†ãƒ«ãƒ¼ãƒ«ã«ãªã‚‹ã¨è©¦ã—ã¦ã„ãªã„ã§ã™ãŒã€inå¥ã®ä¸ã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã®whereå¥ã«ãƒã‚¤ãƒ³ãƒˆä¸Šä½2ä»¶ã‚’å–å¾—ã—ã¦ã€ãƒã‚¤ãƒ³ãƒˆåŒå£«ã§ãã£ã¤ã‘ã‚‹å¿…è¦ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ï¼ˆæ˜Žæ—¥ã§ã‚‚è©¦ã—ã¦ã¿ã‚ˆã†ã‹ãªãƒ»ãƒ»ãƒ»ï¼‰ æŠ•ç¨¿æ—¥æ™‚ : 2007å¹´6æœˆ7æ—¥ 22:10 Feedback #Â re: ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ä¸Šä½nä»¶ã‚’å–å¾—ã™ã‚‹SQL 2007/07/02 17:49 ã˜ã‚ƒã‚“ã¬ãã£ã¨ å½¹ç«‹ã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ãã€‚ http://www.atmarkit.co.jp/bbs/phpBB/viewtopic.php?topic=39369&forum=26 #Â re: ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ä¸Šä½nä»¶ã‚’å–å¾—ã™ã‚‹SQL 2007/07/02 19:22 ã‹ã¤ã®ã‚Š ã³ã£ãã‚Šã—ãŸï½— #Â ???????
Itisango 2017/04/08
ã“ã†ã„ã†ã®è‹¦æ‰‹.

SQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

SELECT

æ¤œç´¢

ä¸Šä½

æŠ½å‡º
ãƒªãƒ³ã‚¯
MySQL 5.7æ–°æ©Ÿèƒ½è§£èª¬ï¼šãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç·¨
ä»Šæœˆã®é ã€è©³è§£MySQL 5.7ã®å‡ºç‰ˆè¨˜å¿µç¬¬ä¸€å¼¾ã¨ã—ã¦ã€MyNAï¼ˆæ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼šï¼‰åç¾©ã§ã‚¤ãƒ™ãƒ³ãƒˆã‚’è¡Œã£ãŸã®ã§ã€ãã®éš›ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ç´¹ä»‹ã—ã¦ãŠã“ã†ã€‚ä»Šå›žç´¹ä»‹ã—ãŸæ–°æ©Ÿèƒ½ã®ã‚«ãƒ†ã‚´ãƒªã¯2ã¤ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®é‹ç”¨ã¨åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Šé›¢ã›ãªã„ã»ã©é‡è¦ãªã‚‚ã®ã§ã‚ã‚Šã€ãã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã«ã¨ã£ã¦ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãŒé‡è¦ã§ã‚ã‚‹ã“ã¨ã¯ã€è¨€ã†ã¾ã§ã‚‚ãªã„ã ã‚ã†ã€‚ ä»Šå›žã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¤§ããé€²åŒ–ã—ã¦ã„ã‚‹ã€‚ ã¾ãšã€MySQL 5.7ã§ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒˆãƒãƒã‚¸ã®é™ç•Œã‚’æ‰“ã¡ç ´ã£ãŸï¼ï¼MySQL 5.6ã¾ã§ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯ã²ã¨ã¤ã®ãƒžã‚¹ã‚¿ãƒ¼ã—ã‹æŒã¤ã“ã¨ãŒã§ããªã„ã¨ã„ã†åˆ¶ç´„ãŒã‚ã£ãŸã®ã ãŒã€ãã‚ŒãŒãªããªã£ãŸã€‚ã™ãªã‚ã¡ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒè¤‡æ•°ã®ãƒžã‚¹ã‚¿ãƒ¼ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’é€£ç¶šçš„ã«è¤‡è£½ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§ã‚ã‚‹ã€‚ãã‚Œã«ã‚ˆã‚Šã€ã“ã‚Œã¾ã§ä»¥ä¸Šã«æ§˜ã€…ãª
Itisango 2016/09/29
MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

SQL

5.7

ã‚ã¨ã§èªã‚€

programming

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

software

development
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸