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

honamis id:honamis

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

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

Chromeé–‹ç™ºãƒãƒ¼ãƒ ãŒSQLiteãƒãƒ¼ãƒ ã¨WebAssemblyç‰ˆSQLiteã‚’é–‹ç™ºä¸ã€‚Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã‹ã‚‰ã®ãƒ•ã‚¡ã‚¤ãƒ«æ›¸ãè¾¼ã¿ã§æ°¸ç¶šåŒ–ã‚‚å¯èƒ½ã€‚Web SQL APIã®ä»£æ›¿ã¨ã—ã¦
Chromeé–‹ç™ºãƒãƒ¼ãƒ ãŒSQLiteãƒãƒ¼ãƒ ã¨WebAssemblyç‰ˆSQLiteã‚’é–‹ç™ºä¸ã€‚Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã‹ã‚‰ã®ãƒ•ã‚¡ã‚¤ãƒ«æ›¸ãè¾¼ã¿ã§æ°¸ç¶šåŒ–ã‚‚å¯èƒ½ã€‚Web SQL APIã®ä»£æ›¿ã¨ã—ã¦ Google Chromeã®é–‹ç™ºãƒãƒ¼ãƒ ã¯ã€ã™ã§ã«éžæŽ¨å¥¨ã¨ãªã£ã¦ã„ã‚‹Webæ¨™æº–ã®Web SQL Database APIã‚’Chromeã‹ã‚‰å‰Šé™¤ã€ãã®ä»£æ›¿æ©Ÿèƒ½ã¨ã—ã¦SQLiteé–‹ç™ºãƒãƒ¼ãƒ ã¨å”åŠ›ã—ã¦WebAssemblyç‰ˆã®SQLiteã‚’é–‹ç™ºã—ã€æä¾›ã™ã‚‹äºˆå®šã§ã‚ã‚‹ã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ Chrome is deprecating and eventually removing Web SQL! Read @tomayacâ€™s post that details all the steps for getting there. [We are here] Chrome 105 shows a deprecation w
honamis 2022/09/05
sql

sqlite
ãƒªãƒ³ã‚¯
SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ - Qiita
ã¯ã˜ã‚ã« æœ¬æ–‡æ›¸ã¯SQLã®ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ã§ã™ã€‚ Pythonã‚„Rubyã®ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«ã¯æœ‰åãªã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ãŒã‚ã‚Šã€å…±é€šã®ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆãƒ«ãƒ¼ãƒ«ã«æ²¿ã£ãŸã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã‚„å‘½åè¦å‰‡ã«å‰‡ã£ãŸã‚³ãƒ¼ãƒ‰ãŒç”Ÿã¿å‡ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ä¸€æ–¹ã€SQLã«ã¯çŸ¥ååº¦ã®ã‚ã‚‹çµ±ä¸€ã•ã‚ŒãŸã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã®ãŸã‚ã€æ€ã„ã®ã¾ã¾ã«æ›¸ã‹ã‚ŒãŸSQLãŒæ•£è¦‹ã•ã‚Œã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã€SQLã‚’ä½¿ã£ã¦ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªåˆ†æžã‚’è¡Œã†å ´åˆã¯ã€å¿…ãšã—ã‚‚ãƒ«ãƒ¼ãƒ«ã«æ²¿ã†å¿…è¦ã¯ãªãã€åŠ¹çŽ‡ã‚ˆãæ›¸ã„ã¦ã‚‚è‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚„ãƒãƒƒãƒã®ä¸ã«çµ„ã¿è¾¼ã‚€ã‚ˆã†ãªã‚‚ã®ã€ã¤ã¾ã‚Šè‡ªåˆ†ä»¥å¤–ã®èª°ã‹ã«èªã¾ã‚Œã‚‹SQLã¯ã€å¤šãã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžåŒæ§˜ã«ä½•ã‚‰ã‹ã®ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ã«æ²¿ã†ã“ã¨ã§å¤šãã®ãƒ¡ãƒªãƒƒãƒˆã‚’äº«å—ã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã‚¯ã‚¨ãƒªãŒæ§‹é€ åŒ–ã•ã‚Œã€å¯èªæ€§ãŒé«˜ã¾ã‚‹ ãƒã‚°ã®ç™ºè¦‹ã‚„ä¿®æ£ãŒå®¹æ˜“ã«ãªã‚‹ æ”¹è¡Œä½ç½®ã‚„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆãªã©ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®æ‚©ã¿ãŒè§£æ¶ˆã•ã‚Œã‚‹ ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ã‚’å…±
honamis 2015/12/19
sql
ãƒªãƒ³ã‚¯
C# ã§ä½¿ãˆã‚‹ SQL Builder ã‚’é›†ã‚ã¦ã¿ãŸ - kendik.net
O/R ãƒžãƒƒãƒ‘ãƒ¼ã§ãªãã¦ SQL ã ã‘ã‚’ä½œã£ã¦ãã‚Œã‚‹ãƒ˜ãƒ«ãƒ‘ãƒ¼ãŒæ¬²ã—ã„ãªãã¨æ€ã„ã¾ã—ã¦(å…·ä½“çš„ã«ã¯ Dapper ã«é£Ÿã‚ã›ã‚‹ SQL ã‚’ä½œã‚ŠãŸã„)ã€SQL Builder çš„ãªã‚‚ã®ã‚’æŽ¢ã—ã¦ã¿ã¾ã—ãŸã€‚O/R ãƒžãƒƒãƒ‘ãƒ¼ã‚‚æ··ã˜ã£ã¡ã‚ƒã£ã¦ã¾ã™ãŒã€çµæ§‹è¦‹ã¤ã‹ã‚‹ã‚‚ã‚“ã§ã™ãã€‚ è©³ç´°ã¯ã¾ãŸå¾Œæ—¥ç¢ºèªã™ã‚‹ã¨ã—ã¦ã€å‚™å¿˜ãŒã¦ã‚‰ã¨ã‚Šã‚ãˆãšæ¦‚è¦ã ã‘ã€‚ã‚µãƒ³ãƒ—ãƒ«ã¯é©å½“ã«å…¬å¼ã‹ã‚‰å¼•ã£å¼µã£ã¦ãã¦ã‚‹ã ã‘ã§å‹•ä½œç¢ºèªã—ã¦ã¾ã›ã‚“ã€‚ Enexure.Sql.Dynamic https://github.com/Enexure/Enexure.Sql.Dynamic/ var tableA = new Table("TableA").As("a"); var tableB = new Table("TableB").As("b"); var query = Query .From(tableA) .Join(tableB, Express
honamis 2015/11/12
C#

programming

sql

.net
ãƒªãƒ³ã‚¯
2è¡Œæ›¸ãã‹ãˆã‚‹ã ã‘ã§SQLã‚’ãƒã‚°ã«å‡ºåŠ›ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹go-sql-tracerã‚’ä½œã‚Šã¾ã—ãŸ - walf443's blog
isuconäºˆé¸ä¸ã«ã€SQLã‚’å‡ºåŠ›ã—ãŸããªã£ãŸã®ã ã‘ã©ã€ãµã¨github.com/shogo82148/go-sql-proxyã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã¨ã—ã¦ã¨ã‚Šã‚ãˆãšç°¡å˜ã«ä½¿ã†æ–¹æ³•ãŒæ›¸ã„ã¦ãªãã¦å°‘ã—ä½¿ã„æ–¹ã‚’èª¿ã¹ã‚‹ã®ã«è‹¦åŠ´ã—ãŸã®ã§ã€isuconã§æ™‚é–“ã®ãƒã‚¹ãªãä½¿ãˆã‚‹ã‚ˆã†ã«ãã®wrapperã‚’æ›¸ãã¾ã—ãŸã€‚ package main import ( database/sql "github.com/go-sql-driver/mysql" # load driver before load go-sql-tracer _ "github.com/walf443/go-sql-tracer" ) func main() { db, err := sql.Open('mysql:trace', dsn) } ãƒã‚¤ãƒ³ãƒˆã¯ã€ å…ƒã€…ä½¿ã£ã¦ã„ãŸãƒ‰ãƒ©ã‚¤ãƒåã«":trace"ã¨ã¤ã‘ã‚‹ã“ã¨ go-sql-driver/
honamis 2015/11/01
sql

golang

logging
ãƒªãƒ³ã‚¯
CSVå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ã‚’SQLã‚’ä½¿ã£ã¦è§£æžã™ã‚‹æ–¹æ³• - ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢
å°å· æ˜Žå½¦, é˜ªäº• èª : ãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™º æ—¥æœ¬ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã®ç¾å ´ã§ç”Ÿã¿å‡ºã•ã‚ŒãŸã€Œãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™ºã€ã¨ã„ã†æ¦‚å¿µã‚’ã€æ•°å¤šãã®å®Ÿä¾‹ã‚’å…ƒã«ãƒ¢ãƒ‡ãƒ«åŒ–ãƒ»ä½“ç³»åŒ–ã‚’è©¦ã¿ãŸæœ€åˆã®æœ¬ã€‚ å°å· æ˜Žå½¦, é˜ªäº• èª : Redmineã«ã‚ˆã‚‹ã‚¿ã‚¹ã‚¯ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆå®Ÿè·µæŠ€æ³• Redmineã«ã‚ˆã‚‹ãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™ºã®å®Ÿè·µæŠ€æ³•ã«é–¢ã™ã‚‹æœ€åˆã®æœ¬ã€‚ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã¸ã®é©ç”¨æ–¹æ³•ã€TestLinkã«ã‚ˆã‚‹ãƒ†ã‚¹ãƒˆç®¡ç†æ‰‹æ³•ã«ã¤ã„ã¦ã‚‚è¨€åŠã€‚ æ¸…æ°´ å‰ç”·: ã€Œæ´¾ç”Ÿé–‹ç™ºã€ã‚’æˆåŠŸã•ã›ã‚‹ãƒ—ãƒã‚»ã‚¹æ”¹å–„ã®æŠ€è¡“ã¨æ¥µæ„ çµ„è¾¼ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºç‰¹æœ‰ã®ã‚¹ã‚¿ã‚¤ãƒ«ã§ã‚ã‚‹æ´¾ç”Ÿé–‹ç™ºã€ç‰¹ã«XDDPã«ã¤ã„ã¦è§£èª¬ã—ãŸä¸–ç•Œã§ã‚‚ç¨€ãªæœ¬ã€‚æ—¢å˜è£½å“ã‚’ä¿å®ˆã™ã‚‹ã®ã§ã¯ãªãç¶™ç¶šçš„ã«æ©Ÿèƒ½è¿½åŠ ã—ã¦ã„ãæ˜¨ä»Šã®é–‹ç™ºã§ã¯ã€æ´¾ç”Ÿé–‹ç™ºç‰¹æœ‰ã®å•é¡Œã‚’æ„è˜ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚XDDPã¯ãƒ—ãƒã‚»ã‚¹è«–ã ã‘ã§ãªãã€è¦ä»¶å®šç¾©ãªã©ã®ä¸Šæµå·¥ç¨‹ã®å“è³ªæ”¹å–„ã«ã‚‚å½¹ç«‹ã¤ã®ã§æ³¨æ„ã€‚ Le
honamis 2015/08/22
tips

SQL

CSV

tools
ãƒªãƒ³ã‚¯
VOYAGE GROUPã€€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚° : SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã‚¹ã‚¹ãƒ¡
2014å¹´07æœˆ10æ—¥10:32 ã‚«ãƒ†ã‚´ãƒªå‹‰å¼·ä¼šDB SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã‚¹ã‚¹ãƒ¡ ã“ã‚“ã«ã¡ã¯ã‚·ã‚¹ãƒ†ãƒ æœ¬éƒ¨ã€€ä¸‰æµ¦ï¼ hironomiuã§ã™ã€‚ VOYAGE GROUPã§ã¯æ§˜ã€…ãªç¤¾å†…å‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã¦ã„ã‚‹ã®ã§ã™ãŒä»Šå¹´ã®1æœˆã‹ã‚‰oreillyã‹ã‚‰å‡ºç‰ˆã•ã‚Œã¦ã„ã‚‹SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³å‹‰å¼·ä¼šã‚’ä¸‰æµ¦ï¼ hironomiuãŒé–‹å‚¬ã—ã¦ã„ã¾ã—ãŸã€‚ æœ¬ã®å†…å®¹ã¯åå‰ã®é€šã‚ŠSQLï¼ˆRDBMSã¾ã§åºƒã’ãŸï¼‰ã‚’æ‰±ã†éš›ã®ã€Œã¹ã‹ã‚‰ãšã€é›†ã§ã™ã€‚ãªã‹ãªã‹ã®è‰¯æ›¸ãªã®ã§ã¾ã ãŠèªã¿ã§ãªã„æ–¹ã¯ä¸€èªã‚’ãŠã‚¹ã‚¹ãƒ¡ã—ã¾ã™ï¼ å‹‰å¼·ä¼šã®é€²ã‚æ–¹ã§ã™ãŒ é€±1æ™‚é–“1å›žã‚ãŸã‚Š2ç« ï½ž3ç« ã®ãƒšãƒ¼ã‚¹ã§é€²ã‚ã‚‹ãƒ™ãƒ†ãƒ©ãƒ³ã¨è‹¥æ‰‹ã‚’åŒã˜ãã‚‰ã„ã®äººæ•°ï¼ˆåˆè¨ˆã§æœ€å¤§8äººï¼‰ã«ã¦é€²ã‚ã‚‹è¼ªèªã§ã¯ãªãä¸‰æµ¦ï¼ hironomiuãŒãƒ¡ãƒ³ã‚¿ãƒ¼ã¨ã—é€²ã‚ã€é©æ™‚å‚åŠ è€…ãŒçµŒé¨“è«‡ã‚’èªžã‚‹å½¢ã§é€²ã‚ã‚‹ã®ã‚ˆã†ãªå½¢ã§é€²ã‚ã¾ã—ãŸã€‚æœ¬æ¥ã§ã™ã¨1ç« 1é€±ã§ã‚‚è‰¯ã„å†…å®¹ãªã®ã§ã™ãŒå…¨25ç« ã€25é€±ã¯ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç¶æŒã™ã‚‹ã“ã¨ã«ä¸
honamis 2014/07/10
sql
ãƒªãƒ³ã‚¯
PDOã§ã®æ•°å€¤åˆ—ã®æ‰±ã„ã«ã¯ãƒ¯ãƒŠãŒã„ã£ã±ã„ â€” A Day in Serenity (Reloaded) â€” PHP, CodeIgniter, FuelPHP, Linux or something
PHP Advent Calendar 2013 in Adventarã®15æ—¥ç›®ã§ã™ã€‚ ã¿ãªã•ã‚“ã€å²ä¸Šç©ºå‰ã®SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãƒ–ãƒ¼ãƒ ã®ä¸ã€ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãªãŠã€ã€Œæˆ‘ãŒç¤¾ã®ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å¤§ä¸ˆå¤«ãªã®ã‹ï¼Ÿã€ã¨ã„ã†ç–‘å•ã‚’ãŠæŒã¡ã®æ–¹ã«ã¯ã€ä»¥ä¸‹ã®è¨˜äº‹ã‚’ãŠè–¦ã‚ã—ã¾ã™ã€‚ æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«æ£è§£ã¯ãªã„ ã•ã¦ã€ã‚ã¾ã‚Šã«ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒäººæ°—ãªã®ã§ã€ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã«ã‚‚ã†å°‘ã—ãŒã‚“ã°ã£ã¦ã‚‚ã‚‰ã„ãŸã„æ°—ãŒã—ã¾ã—ãŸã€‚ãã“ã§ã€ä»Šæ—¥ã¯ã€ä»¥ä¸‹ã®å¾³ä¸¸ã•ã‚“ã®å¤§å¤‰ã«åŠ›ä½œãªè¨˜äº‹ã«é–¢é€£ã—ãŸã€PDOã§ã®ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã«ã¤ã„ã¦ã®è¨˜äº‹ã‚’æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ PHPã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®è§£èª¬æ›¸12ç¨®é¡žã‚’èªã‚“ã§SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã®è§£èª¬çŠ¶æ³ã‚’èª¿ã¹ã¦ã¿ãŸ | å¾³ä¸¸æµ©ã®æ—¥è¨˜ ä¸€å¿œã€ä»Šã§ã“ãPDOã¯æ™®é€šã«ä½¿ã‚ã‚Œã¦ã„ã¾ã™ãŒã€ç´°ã‹ã„ç‚¹ã¾ã§ã¿ã¦ã„ãã¨ã€ä»•æ§˜ãªã®ã‹ãƒã‚°ãªã®ã‹ã€ã‚ã‚‹ã„ã¯ã“
honamis 2013/12/15
php

PDO

SQL
ãƒªãƒ³ã‚¯
"SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³"ã‚’èªã¿ã€MySQLã«ãŠã‘ã‚‹Nullã®æ‰±ã„ã«ã¤ã„ã¦å†ç¢ºèªã—ãŸã€‚ - be a ninja engineer
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä½œè€…: Bill Karwin,å’Œç”°å“äºº(ç›£è¨³),å’Œç”°çœäºŒ(ç›£è¨³),å…å³¶ä¿®å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2013/01/26ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 9äºº ã‚¯ãƒªãƒƒã‚¯: 674å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (18ä»¶) ã‚’è¦‹ã‚‹ DBMSã‚’ä½¿ã†äººãªã‚‰èª°ã‚‚ãŒãƒãƒžã‚‹Nullã®å–ã‚Šæ‰±ã„ã ãŒã€çµè«–ã‹ã‚‰è¨€ã†ã¨DBMSã®Nullã¯ã‚ˆãã‚ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ è¨€èªžã®ãã‚Œã¨ã¯é•ã†ã®ã§ã€æ–°ã—ã„ç‰©ã¨ã—ã¦æ£ã—ãç†è§£ã—ã‚ˆã†ã¨ã„ã†äº‹ã€‚Nullã‚’æ€–ãŒã£ã¦ã¯çœŸã£å½“ãªãƒ‡ãƒ¼ã‚¿è¨è¨ˆã¯å‡ºæ¥ãªã„ã€‚ DBMSã«ãŠã‘ã‚‹Nullã¨ã¯ å…ˆã«è¿°ã¹ãŸã‚ˆã†ã«ã€DBMSã®Nullã¨ã‚¢ãƒ—ãƒªå´ã®Nullã¯å…¨ãã®åˆ¥ã®ç‰©ã§ã™ã€‚ã‚¢ãƒ—ãƒªå´ã®Nullã¯å€¤ãŒå˜åœ¨ã—ãªã„äº‹ã‚’ç¤ºã™ã®ã«å¯¾ã—ã€DBMSã®Nullã¯å€¤ãŒä¸å®šã§ã‚ã‚‹ã“ã¨ã‚’ç¤ºã—ã¾ã™ã€‚(3å€¤è«–ç†ã¨è¨€ã‚ã‚Œã‚‹æ¦‚å¿µãŒå°Žå…¥ã•ã‚Œã¦ã„ã¾ã™ã€‚) ãã®ãŸã‚ã€ä»¥ä¸‹ã®SQLã‚’MySQLã§å®Ÿè¡Œã™ã‚‹ã¨ã€NullãŒçµæžœ
honamis 2013/03/29
sql

null
ãƒªãƒ³ã‚¯
ScriptDom ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã¤ã„ã¦ - ãŠ ã ã®ã‚¹ãƒšãƒ¼ã‚¹
SqlWorld :: SQLWorldâ˜…å¤§é˜ª#12 ã®å‹‰å¼·ä¼šã§ã€ã€ŒT-SQL ã® Parse ã¨ Generateã€ã¨ã„ã†é¡Œã§ç™ºè¡¨ã—ã¾ã—ãŸã€‚ ç™ºè¡¨å¾Œã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã¤ã„ã¦è³ªå•ãŒã‚ã£ãŸã®ã§ã€è£œè¶³ã¨ã—ã¦æ›¸ã„ã¦ãŠãã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã«ã¯ã€ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã¤ã„ã¦ç‰¹ã«æ›¸ã‹ã‚Œã¦ã¯ãŠã‚‰ãšã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ¡é …ãŒå‡ºã¦ãã‚‹ã®ã§ãã“ã§ç¢ºèªã—ã¦ãã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆå…¬å¼ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ã‚»ãƒ³ã‚¿ãƒ¼ã‹ã‚‰ MicrosoftÂ® SQL ServerÂ® 2012 Feature Pack ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸ã«å‡ºã¦ãã‚‹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ¡é …ã‚’èªã‚ã°å†é ’å¸ƒå¯èƒ½ã§ã‚ã‚‹äº‹ç‰ãŒæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã®ã§ã€æ°—ã«ãªã‚‹æ–¹ã¯æ˜¯éžã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ¡é …ã‚’ã‚ˆãç¢ºèªãã ã•ã„ã€‚ ç™ºè¡¨è³‡æ–™ã¯ã“ã¡ã‚‰ T sql ã® parse ã¨ generator from Oda Shinsuke
honamis 2013/03/28
sql

SQLServer

.net
ãƒªãƒ³ã‚¯
T-SQL ã® ãƒ‘ãƒ¼ã‚µãƒ¼ã¨ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ãƒ¼(ScriptDom)ã®ç´¹ä»‹ - ãŠ ã ã®ã‚¹ãƒšãƒ¼ã‚¹
SQL Server ç”¨ã® SQL ã§ã‚ã‚‹ T-SQL ã«ã¯ã€ãƒ‘ãƒ¼ã‚µãƒ¼ã¨ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ãƒ¼ãŒ MS ã‹ã‚‰ .NET Framework ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ æœ€æ–°ã® 2012 ã§ã¯ã“ã¡ã‚‰ Microsoft.SqlServer.TransactSql.ScriptDom åå‰ç©ºé–“ () ä¸€ã¤å‰ã¯ã“ã¡ã‚‰ Microsoft.Data.Schema.ScriptDom åå‰ç©ºé–“ () Microsoft.Data.Schema.ScriptDom.Sql åå‰ç©ºé–“ () åå‰ç©ºé–“ãŒå¤‰ã‚ã£ã¦ã„ã¾ã™ãï¼ æ˜”ã®æ–¹ã¯ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¨å®Ÿè£…ã‚’åˆ†ã‘ã¦ã„ã¦ä»–ã®DBã§ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã—ãŸãŒã€æœ€æ–°ã§ã¯ T-SQL(SQL Server)ä¸€æœ¬ã«ãªã£ã¦ã„ã¾ã™ã€‚*1 ã©ã‚“ãªã¨ã“ã‚ã§ä½¿ã†ã®ã‹ã¨ã„ã†ã¨ã€VS2010 ã®ã“ã‚ã®è¨˜äº‹ã§ã™ãŒ SQL ã®é™çš„è§£æžã§ä½¿ç”¨ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒˆ
honamis 2013/02/25
sql

microsoft

.NET

sqlserver
ãƒªãƒ³ã‚¯
https://pldoc.sourceforge.net/maven-site/
honamis 2013/01/11
sql

document

plsql

programming
ãƒªãƒ³ã‚¯
[MySQL] ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å–å¾—ç³»ã® SQL ã¾ã¨ã‚ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
å¤ä¼‘ã¿ã¾ã å–ã‚Œã¦ãªã„ã‚ˆï½žãƒ»ãƒ»ãƒ»å¤çµ‚ã‚ã£ã¡ã‚ƒã†ã‚ˆï½žãƒ»ãƒ»ãƒ»ã¿ãªã•ã‚“ã€ã“ã‚“ã¡ã«ã¯ nakamura ã§ã™ã€‚ ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ DB ã¸ã®æ›´æ–°ãƒ»å‚ç…§ç‰ã¯æ—¥ã€…ä½¿ã†ã®ã§å‰²ã‚Šã¨è¦šãˆã‚„ã™ã„ã§ã™ãŒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç‰è¡Œã†éš›ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ MySQL è‡ªä½“ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚’å–å¾—ã™ã‚‹ SQL ã£ã¦ã—ã‚‡ã£ã¡ã‚…ã†ä½¿ã†ã‚ã‘ã§ã¯ãªã„ã®ã§çµæ§‹å¿˜ã‚ŒãŒã¡ã§ã™ã‚ˆãï½žã€‚ä»Šæ—¥ã¯ãã®è¾ºã‚Šã® SQL æ–‡ã‚’å‚™å¿˜éŒ²ã‚‚å…¼ãã¦ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«é–¢é€£ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚’å–å¾—ã€‚ show tables; ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã‚’å–å¾—ã€‚ describe table_name; ; describe ã«ã¯ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ desc table_name; CREATE TABLE æ–‡ã‚’å–å¾—ã€‚ show create table table_name; ãƒ†ãƒ¼ãƒ–ãƒ«ã®çŠ¶æ…‹ã‚’å–å¾—ã€‚ ; å…¨ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¡¨ç¤º show table st
honamis 2012/08/30
database

sql

mysql
ãƒªãƒ³ã‚¯
SQL Syntax Highlighting - Visual Studio Marketplace
Adds basic SQL syntax highlighting (keywords, functions and variables) to string literals. This Visual Studio 2010 extension adds basic SQL syntax highlighting (keywords, functions and variables) to string literals. Currently the following keywords are supported: select,Â insert,Â delete,Â update, into,Â values,Â truncate,Â distinct,Â top,Â with, from, join, inner join, outer join, left outer join, right
honamis 2012/03/13
Visual Studio

extension

sql
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/entry/column_sqltunig_ocs
honamis 2011/08/21
sql

Oracle
ãƒªãƒ³ã‚¯
SQLã£ã¦ã‚ã°ã°ï¼Ÿ
ãƒãƒ¼ãƒ• ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆ@ãƒˆãƒ¬ã‚¸ãƒ£ @doryokujin NoSQLå‘ã‘ã®ã‚¯ã‚¨ãƒªè¨€èªžã€ŒUnQLã€ - SQLiteã¨CouchDBé–‹ç™ºè€…ã‚‰ç™ºè¡¨ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ« - http://bit.ly/ocvvLl 2011-08-08 11:14:29
honamis 2011/08/10
nosql

sqlite

sql
ãƒªãƒ³ã‚¯
ORMãŒã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã‚ã‚‹11ã®ç†ç”±
ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã®ãƒ—ãƒã‚°ãƒ©ãƒžLaurie Vossæ°ãŒæ›¸ã„ãŸè¦‹é€ƒã›ãªã„è¨˜äº‹ãŒè³‘ã‚ã£ã¦ã„ã¾ã™ã€‚è¿‘å¹´ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®å®šç•ªä¸ã®å®šç•ªORãƒžãƒƒãƒ‘ãƒ¼ãŒæ—¢ã«ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ãªã®ã§ã¯ã¨ã„ã†ã®ãŒå½¼ã®ä¸»å¼µã§ã™ã€‚ã“ã®è¨˜äº‹ã‚’æ›¸ããã£ã‹ã‘ã«ãªã£ãŸã®ã¯ã“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã ãã†ã§ã™ã€‚ I cannot overstate the degree to which ORM is a dangerous antipattern. â€” Laurie Voss (@seldo) June 9, 2011 ORM ãŒå±é™ºãªã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã ã£ã¦ã„ã†ã®ã¯ã©ã‚Œã ã‘è¨€ã£ã¦ã‚‚è¨€ã„éŽãŽã‚‹ã“ã¨ã¯ãªã„ ã“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã«å¯¾ã—ã¦å„æ–¹é¢(ActiveRecord, Doctrine, Hibernate)ã‹ã‚‰å¤šãã®ï¼ˆæ¿€ã—ã„ï¼‰è¿”ä¿¡ãŒå¯„ã›ã‚‰ã‚Œã¦æ›¸ã‹ã‚ŒãŸã®ãŒå•é¡Œã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ã¾ãšã¯ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã¯ä½•ã‹ã®å®šç¾©ã¨ã—ã¦ä¸‹è¨˜ã®2ã¤ã‚’æŒ™ã’ã¦ã„ã¾ã™ã€‚ å½“åˆã¯æœ‰ç›Š
honamis 2011/06/18
orm

programming

database

sql
ãƒªãƒ³ã‚¯
neue cc - DbExecutor ver.2 - C#ã§ã®ç”ŸSQLæ›¸ãè£œåŠ©ãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç”¨ã®ã©ã“ã«ã§ã‚‚è»¢ãŒã£ã¦ã„ãã†ãªã‚·ãƒ³ãƒ—ãƒ«ãªãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã€Part2ã€‚å…¨é¢çš„ã«ã¤ãã‚Šç›´ã—ã¾ã—ãŸ(Part1ã‚‚ã‚ã‚Šã¾ã—ãŸã€ä¸€å¹´å‰ã«å…¬é–‹ã—ã¦ã¾ã™ã€ãŒã€æ£ç›´ã‚¤ãƒžã‚¤ãƒã ã£ãŸï¼)ã€‚ DbExecutor - Simple and Lightweight Database Executor NuGet - DbExecutor ä½•ã§ã“ã®æ™‚æœŸã«ï¼Ÿã¨ã„ã†ã¨ã€ç¨ã‚“ã§ã„ã‚‹ã®ã¯WP7ã«SQLCEãŒä¹—ã‚‹ã¨ã„ã†è©±ã€ã§ã™ã€‚ã¾ã‚ã€Linq to HogeãŒç©ã¾ã‚Œã‚‹ã‚ˆã†ãªã®ã§ã€ã‚¤ãƒ©ãƒãƒ¼ã ã‚ã¨ã„ã†è©±ã¯ã‚ã‚‹ã®ã§ã™ãŒï¼ã‚ã‚‹ã®ã§ã™ãŒã€ãã‚Œã§ã‚‚ç”ŸSQLã‚’ä½¿ã‚ã–ã‚‹ã‚’å¾—ãªã„ã‚·ãƒãƒ¥ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ã¯å‡ºã¦ãã‚‹ã¯ãšã§ã€ãã®ãŸã‚ã«ã€ä»Šã®ã†ã¡ã«ä½œã£ã¦ãŠã/ä½œã‚ŠãªãŠã—ã¦ãŠã“ã†ã‹ã¨ã€‚ã¾ã WP7ã§ã©ã†ã„ã†å½¢ã§è¼‰ã‚‹ã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ã€ä»Šã¯æ™®é€šã«.NET 4 Client Profileç”¨ã§ã™ã€‚WP7ã¸ã¯SDKãŒå‡ºæ¬¡ç¬¬ã€ã™ãã«å¯¾å¿œã•ã›ã‚‹ã¤ã‚‚ã‚Šã€‚ ã•ã¦
honamis 2011/04/30
c#

ADO.NET

sql
ãƒªãƒ³ã‚¯
é–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ ç¬¬5ç«
ç›®æ¬¡ Part1ã€€DBæŽ¥ç¶šã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ç®¡ç†æ€§ã‚’æœ€å¤§åŒ–ã™ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®ä»•çµ„ã¿ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Ÿ æŽ¥ç¶šã™ã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚° ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®æ§‹æˆè¦ç´ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã«ä»˜éšã™ã‚‹æŠ€è¡“ å…±æœ‰ã‚µãƒ¼ãƒãƒ¼æ§‹æˆ OCIã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚° Part2ã€€Java ï¼†.NETã§ä½¿ãˆã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ç©¶æ¥µã®é¸æŠž Javaã«ãŠã‘ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚° ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®é¸æŠžåŸºæº– ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®å®Ÿè£…ã®ç´¹ä»‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®åˆ‡ã‚Šæ›¿ãˆ .NETã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚° ãŠã‚ã‚Šã« Part1ã€€DBæŽ¥ç¶šã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ç®¡ç†æ€§ã‚’æœ€å¤§åŒ–ã™ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®ä»•çµ„ã¿ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Ÿ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹å‰ã«ã€ã¾ãšã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ï¼Ÿã€ã‚’èª¬æ˜Žã—ã¾ã—ã‚‡ã†ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒOracleã‚’ç”¨ã„ã¦SQLã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã«ã¯ã€Oracleã«S
honamis 2010/05/31
sql

Oracle

article

è³‡æ–™

å¾Œã§èªã‚€

rdbms

performance
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› Oracleã§å®Ÿè¡Œã•ã‚ŒãŸSQLã®ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã®å€¤ã‚’çŸ¥ã‚‹æ–¹æ³•
å„ç¨®ã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“(OSã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯)ã‚„ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã¨ã„ã£ãŸè©±é¡Œã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚è‘—è€…ã¯å°ç”°åœäºŒã€ã€Œé–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹Oracleã®ä»•çµ„ã¿ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹OS/ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸/ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ãªã©ã®è‘—ä½œã‚‚ã‚ã‚Šã¾ã™ ã²ã•ã¶ã•ã«Oracleãƒã‚¿ã«æˆ»ã£ã¦ãã¾ã—ãŸã€‚ é–‹ç™ºã‚„ãƒ†ã‚¹ãƒˆã‚’ã—ã¦ã„ã‚‹ã¨ã€å®Ÿè¡Œã•ã‚ŒãŸSQLã®ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã®å€¤ã‚’çŸ¥ã‚ŠãŸã„ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ä¾‹ãˆã°ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å‹•ã‹ã—ãŸçµæžœã€SQLãŒå®Ÿè¡Œã•ã‚ŒãŸã‘ã‚Œã©ã‚‚ã€ãã®SQLã«è¨å®šã•ã‚Œã¦ã„ã‚‹ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã®ä¾‹ã‚’çŸ¥ã‚ŠãŸã„ã¨ã„ã†å ´åˆã§ã™ã€‚SQL*Plusã‚„é–‹ç™ºãƒ„ãƒ¼ãƒ«ã‹ã‚‰SQLã‚’å®Ÿè¡Œã—ãŸã„ã‚“ã ã‘ã©ã€SQLã«ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ãŒã‚ã‚‹ã¨ã€ãã®ã¾ã¾ã§ã¯å®Ÿè¡Œã§ãã¾ã›ã‚“ã€‚ãã®ãŸã‚ã€å®Ÿéš›ã®å€¤ã‚’çŸ¥ã‚ŠãŸã„ã¨æ€ã„ã¾ã›ã‚“ã‹ï¼Ÿ å®Ÿã¯ã€ã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã›ã‚“ãŒã€SQLãƒˆãƒ¬ãƒ¼ã‚¹ä»¥å¤–ã§ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã®ä¾‹ã‚’ç¢ºèªã™ã‚‹æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚10gR1ä»¥é™ã«
honamis 2010/05/31
sql

Oracle

tips
ãƒªãƒ³ã‚¯
Oracle 11g R1æ–°æ©Ÿèƒ½ã®Pivotã¨UnPivot
ã¯ã˜ã‚ã« Oracle 11g R1æ–°æ©Ÿèƒ½ã®Pivotã¨UnPivotã«ã¤ã„ã¦ã€åŸºæœ¬äº‹é …ã‹ã‚‰ä½¿ç”¨ä¾‹ã¾ã§ã€SQLã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’äº¤ãˆã¦è§£èª¬ã—ã¾ã™ã€‚ å¯¾è±¡èªè€… Oracleã®Pivotã¨UnPivotã‚’ä½¿ã„ãŸã„æ–¹ Oracleã®SQLã®ç†è§£ã‚’æ·±ã‚ãŸã„æ–¹ å¿…è¦ãªç’°å¢ƒ æœ¬ç¨¿ã§æ‰±ã†SQLã¯ã€Oracle 11.1.0.6.0ã§å‹•ä½œç¢ºèªã—ã¾ã—ãŸã€‚SQL Server 2005ä»¥é™ã§ã‚‚å¿œç”¨ãŒå¯èƒ½ã§ã™ã€‚ 1. Pivotã¨UnPivotã¨ã¯ Pivotã¨UnPivotã¯Oracle 11g R1ã®æ–°æ©Ÿèƒ½ã§ã€selectæ–‡ã§ã®è¡Œåˆ—å¤‰æ›ã‚’å®¹æ˜“ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ã¡ãªã¿ã«Pivotã¨UnPivotã¯ã€SQL Server 2005ä»¥é™ã§ã‚‚ä½¿ç”¨ã§ãã¾ã™ã€‚è‹±å’Œè¾žå…¸ã«ã‚ˆã‚‹ã¨Pivotã®æ„å‘³ã¯ã€å‹•è©žã§ã¯ã€Œæ—‹å›žã™ã‚‹ã€ã€åè©žã§ã¯ã€Œä¸å¿ƒ,è»¸,æ—‹å›žè»¸,ã‹ãªã‚ã€ã§ã™ã€‚ ä¸‹è¨˜ã®Oracleã®selectæ–‡ã®è©•ä¾¡é †åºã«ãŠã„ã¦ã€Pivo
honamis 2010/04/18
sql

oracle

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