[B! SQL] Ehrenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Ehren id:Ehren

SQLã«é–¢ã™ã‚‹Ehrenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ãƒžãƒ¼ã‚±ã‚¿ãƒ¼è‡ªèº«ãŒãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ãŸã‚ã«ã€åºƒå‘Šé‹ç”¨ã«dbtã‚’å°Žå…¥ã—ãŸçµŒç·¯ã¨åŠ¹æžœ - MonotaRO Tech Blog
ã“ã‚“ã«ã¡ã¯ã€ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°éƒ¨é–€åºƒå‘Šã‚°ãƒ«ãƒ¼ãƒ—ã®å°æž—ã§ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³åºƒå‘Šé‹ç”¨ã«ä½¿ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿å¤‰æ›å‡¦ç†ã‚’dbtã«ç§»è¡Œã—ãŸéŽç¨‹ã¨å¾—ã‚‰ã‚ŒãŸåŠ¹æžœã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ¢ãƒŽã‚¿ãƒã‚¦ã§ã¯ã€å…¨ç¤¾çš„ãªãƒ‡ãƒ¼ã‚¿æ´»ç”¨ç ”ä¿®ãªã©ã«ã‚ˆã‚Šã€ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ã®ã‚ˆã†ãªãƒ“ã‚¸ãƒã‚¹ç³»ã®éƒ¨ç½²ã§ã‚‚ã€SQLã‚’è‡ªèº«ã§æ›¸ã„ã¦ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã‚’è¡Œã„ã€æ•°å—ã«åŸºã¥ã„ãŸæ„æ€æ±ºå®šã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ãã®ä¸€æ–¹ã§ã€é›†è¨ˆå¾Œã®æ•°å€¤ã®ã‚ºãƒ¬ã‚„ãƒ‰ãƒ¡ã‚¤ãƒ³å›ºæœ‰ã®ãƒ‡ãƒ¼ã‚¿ã®å“è³ªç®¡ç†ãªã©ã€æ´»ç”¨ãŒé€²ã‚“ã ä¼æ¥ãªã‚‰ã§ã¯ã®èª²é¡Œã¨ã„ã†ã®ã‚‚è¡¨é¢åŒ–ã—ã¦ãã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³åºƒå‘Šé‹ç”¨ã«ãŠã„ã¦ã¯ã€æŠ•ä¸‹ã—ãŸè²»ç”¨ãªã©é…ä¿¡å®Ÿç¸¾ã®ãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€åºƒå‘Šåª’ä½“ã¸ã®ãƒ‡ãƒ¼ã‚¿é€ä¿¡ãªã©ã®ã„ã‚ã‚†ã‚‹ELTã‚’å®‰å®šçš„ã«å›žã™ä»•çµ„ã¿ãŒå¿…è¦ã«ãªã‚Šã¾ã™ãŒã€å‡¦ç†ã®è‡ªå‹•åŒ–ã‚„ãƒ‡ãƒ¼ã‚¿ã®å“è³ªã¾ã§æ±‚ã‚ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã€ã€Œãƒ‡ãƒ¼ã‚¿ãŒæŠ½å‡ºã§ãã‚‹ã€ã ã‘ã§ã¯é™ç•ŒãŒè¦‹ãˆã¦ãã¦ã„ã¾ã—ãŸã€‚ãã“ã§ä»Šå›žã€ãƒžãƒ¼ã‚±ã‚¿ãƒ¼è‡ªèº«ãŒãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ç«‹å ´ã«
Ehren 2023/02/15
BigQuery

sql
ãƒªãƒ³ã‚¯
InfiniSQL
Extreme Scale Transaction Processing InfiniSQL is the database for alwaysÂ on, rapidÂ growth applications that need to collect and analyze in realÂ time--even for complex transactions.
Ehren 2013/12/06
sql

database
ãƒªãƒ³ã‚¯
Postgres: Add constraint if it doesn't already exist
Ehren 2012/10/31
postgresql

sql
ãƒªãƒ³ã‚¯
ç¾å ´ã§ç”Ÿã‹ã›ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’æƒœã—ã¿ãªãä¼æŽˆï¼ ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã¨äº‹å‰å¯¾ç–ã«å½¹ç«‹ã¤ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ | oracletech.jp
ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ãŠã„ã¦ã€é¿ã‘ã¦ã¯é€šã‚Œãªã„SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’ã„ã‹ã«ã—ã¦è§£æ±ºã—ã€äºˆé˜²ã™ã‚‹ã®ã‹ã‚’è§£èª¬ã—ãŸä¸€å†Šã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã¨äº‹å‰å¯¾ç–ã«å½¹ç«‹ã¤ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã®ã”ç´¹ä»‹ã§ã™ã€‚ ã€€ä»¥å‰æœ¬ã‚³ãƒ¼ãƒŠãƒ¼ã§ã”ç´¹ä»‹ã—ãŸã€Oracle ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®åŠ è—¤ç¥¥å¹³æ°ã€ä¸å³¶ç›Šæ¬¡éƒŽæ°ã«ã‚ˆã‚‹ã€ŒåŸºç¤Žã‹ã‚‰å¦ã¶ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã«åŠ ç†ãƒ»æ”¹ç¨¿ã—ãŸæ–°è£…ç‰ˆã¨ãªã‚‹æœ¬æ›¸ã¯ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è‹¦åŠ´ã‚’ä¸–ã®ä¸ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‹ã‚‰å°‘ã—ã§ã‚‚æ¸›ã‚‰ã—ãŸã„ã€ã¨ã„ã†æƒ³ã„ã®ã‚‚ã¨ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã®ç™ºç”Ÿç†ç”±ã‚’æ‰ãˆã‚‹ã€ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’ã€Žè§£æ±ºã€ã™ã‚‹ã€ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’ã€Žäºˆé˜²ã€ã™ã‚‹ã€ã®3ã¤ã‚’ãƒ†ãƒ¼ãƒžã«ã€å®šåž‹çš„ã«å®Ÿæ–½å¯èƒ½ãªåŸºç¤Žçš„ãªã‚‚ã®ã‹ã‚‰ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’è¸ã¾ãˆãŸå¿œç”¨çš„ãªã‚‚ã®ã¾ã§ã€ã•ã¾ã–ã¾ãªè¦³ç‚¹ã‹ã‚‰SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒŽã‚¦ãƒ
Ehren 2012/04/06
oracle

sql
ãƒªãƒ³ã‚¯
NoSQL Data Modeling Techniques
NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. This aspect of NoSQL is well-studied both in practice and theory because specific non-functional properties are often the main justification for NoSQL usage andÂ fundamental results on distributed systems like theÂ CAP theoremÂ apply well to NoSQL systems. Â At the same time, NoSQL
Ehren 2012/03/02
ã‚ã¨ã§ã˜ã£ãã‚Šèªã‚€ã‹ã€‚é¢ç™½ã„ã‚“ã ã‘ã©é•·ã„ãªãƒ¼

sql

NoSql

kvs

readItLater
ãƒªãƒ³ã‚¯
SQL Fiddle - Online SQL Compiler for learning & practice
During Phase 1, only users who are logged in can access the AI chat feature. SQL Fiddle is free to use and ad-free! Want to help us? It takes 10 seconds Step 1: Like & Share our EFE Bulk Extensions videos Step 2: Like & Share our EFE Bulk Insert videos Thank During Phase 1, only users who are logged in can access the AI Editor feature. SQL Fiddle is free to use and ad-free! Want to help us? It tak
Ehren 2012/03/02
DB2ã‚‚å…¥ã‚Œã¦ãã‚Œã‚“ã‹ã®ã†

sql

postgreSQL

mysql

oracle
ãƒªãƒ³ã‚¯
How do I show SQL with Play Framework?
Ehren 2011/10/29
playframework

log

sql

jpa
ãƒªãƒ³ã‚¯
P6spyã§SQLã‚’å‡ºåŠ›ã•ã›ã‚‹ - ãƒãƒ©è£é–‹ç™ºæ—¥è¨˜
P6spyã§SQLå‡ºåŠ› P6spyã§SQLã‚’ãƒã‚°ã«å‡ºåŠ›ã•ã›ã‚‹æ‰‹é †ã‚’ãƒ¡ãƒ¢ã€‚ é©ç”¨ã™ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¯Eclipseã®WTPã‚’ä½¿ç”¨ã—ãŸWebã‚¢ãƒ—ãƒªã€‚ ã‚µãƒ¼ãƒãƒ¼ã«Tomcat5.5ã€‚DBã¯Oracleã§ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã—ã¦æŽ¥ç¶šã€‚ 1) p6spy.jar ã‚’ WEB-INF/lib ã«é…ç½® 2) spy.properties ã‚’ä¸‹è¨˜ã®ã‚ˆã†ã«æ›¸ãæ›ãˆã¦ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã®é€šã£ãŸå ´æ‰€ã«é…ç½®ã€‚ï¼ˆä»Šå›žã¯srcç›´ä¸‹ï¼‰ ################################################################# # P6Spy Options File # # See documentation for detailed instructions # ################################################################
Ehren 2011/09/20
java

sql

jpa
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã‚’çŸ¥ã‚‹
SQLã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¯å¥¥ãŒæ·±ã„ã€‚ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ã€ãã†è¨€ãˆã‚‹ã ã‚ã†ã€‚ ã¿ãªã•ã‚“ã”æ‰¿çŸ¥ã®é€šã‚Šã€åŒã˜çµæžœã‚’å‡ºã™ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚‚ã€SQLã®æ›¸ãæ–¹æ¬¡ç¬¬ã§å‡¦ç†æ™‚é–“ã«ä½•å€ã‚‚ã®å·®ãŒç”Ÿã˜å¾—ã‚‹ã€‚åŠ¹çŽ‡ã®æ‚ªã„SQLã‚’æ›¸ã„ã¦ã—ã¾ã†åŽŸå› ã¯ã€å¤šãã®å ´åˆã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹ç†è§£ä¸è¶³ã§ã‚ã‚‹ã€‚ä¸¡è€…ã‚’ã‚ˆãçŸ¥ã£ãŸä¸Šã§æœ€é©ãªSQLã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã®é‡è¦ãªã‚¹ã‚ãƒ«ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ ç‰¹é›†ã€ŽåŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ã€ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã«ã¤ã„ã¦ã€åŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¦ã„ã‚‹ã€‚SQLãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«å½¹ç«‹ã¤ã“ã¨ã¯ã‚‚ã¡ã‚ã‚“ã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ãŸã‚ã®åŸºç¤ŽçŸ¥è˜ã¨ã—ã¦ã‚‚ä¸å¯æ¬ ã ã€‚ ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ Part 1ï¼šSQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ SQLå®Ÿè¡Œã¾ã§ã®
Ehren 2011/07/01
ã‚ã¨ã§ã˜ã£ãã‚Šèªã‚€

SQL

RDBMS
ãƒªãƒ³ã‚¯
SQL ã§æ•°å¼ã‚’è©•ä¾¡ (å®Œå…¨ç‰ˆ + Î±) - ãã‚‹ãã‚‹ï½ž
å¤§é˜ªã§åƒãå‹äºº mi ã¨ã®åˆä½œ*1ã§ä¸å®Œå…¨ç‰ˆãŒå®Œå…¨ç‰ˆã«ï¼ ã‚„ã£ã±ã‚Š mi ã¯ã™ã”ã‹ã£ãŸï¼ï¼ WITH Input(id, str) AS ( -- idã¨æ•°å¼ã‚’æ¸¡ã™ SELECT 1, '1 + 3 / -8' UNION ALL SELECT 2, '2*3*4*5+99' UNION ALL SELECT 3, '4 * (9 - 4) / (2 * 6 - 2) + 8' UNION ALL SELECT 4, '1 + ((123 * 3 - 69) / 100)' UNION ALL SELECT 5, '2.45/8.5*9.27+(5*0.0023)' ) , Separators(i, ch, str_src, priority) AS ( SELECT 1, '-', 1, 1 UNION ALL SELECT 2, '+', 1, 1 UNION ALL SELECT
Ehren 2011/05/11
å¤‰æ…‹ã ãƒ¼ï¼ˆã„ã„æ„å‘³ã§

sql
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆé–‹ç™ºã«ãŠã‘ã‚‹ãƒ†ã‚¹ãƒˆç”¨DBã®(ä½¿ã„|ä½œã‚Š)æ–¹
æ˜”æ›¸ã„ãŸã‚ˆã†ãªæ°—ãŒã—ã¦ãŸã‘ã©æ›¸ã„ã¦ãªã‹ã£ãŸã®ã§ã€‚ ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã¤ãã£ã¦ã„ã¦DBå›žã‚Šã®ãƒ†ã‚¹ãƒˆã‚’æ›¸ããŸã„å ´åˆã¯ Test::mysqldã‚„Test::postgresql ã‚’ä½¿ã†ã“ã¨ã€‚ CPANãªã‚“ã‹ã«ä¸Šã’ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã¯ãªãã€ãŠä»•äº‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¦ DBå›žã‚Šã®ãƒ†ã‚¹ãƒˆã‚’æ›¸ããŸã„ã‚±ãƒ¼ã‚¹ã«ã¤ã„ã¦ã§ã™ã€‚ ç§ã¯MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã€Test::mysqldã‚’ã¤ã‹ã£ã¦ã‚‚ã‚ˆã„ã®ã§ã™ãŒã€ èµ·å‹•ã‚³ã‚¹ãƒˆãŒãã‚Œãªã‚Šã«ã‹ã‹ã‚‹ã®ã¨ã€ãƒãƒ¼ã‚«ãƒ«ã®é–‹ç™ºç’°å¢ƒã«ã¯æ—¢ã«MySQLã¯ç«‹ã¡ä¸ŠãŒã£ã¦ã„ã‚‹å‰æãŒã‚ã‚‹ã®ã§ã€ æ—¢ã«ç«‹ã¡ä¸ŠãŒã£ã¦ã„ã‚‹MySQLã‚’ãã®ã¾ã¾åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã‚’ã¨ã£ã¦ã„ã¾ã™ã€‚ ãã“ã§ãƒ†ã‚¹ãƒˆç”¨ã®ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã‚¯ãƒ©ã‚¹ã‚’ç´¹ä»‹ã—ã¦ã¿ã¾ã™ã€‚ package t::Utils; use strict; use warnings; use utf8; use lib './t/'; use Test::Fixtu
Ehren 2010/12/15
db

test

sql
ãƒªãƒ³ã‚¯
ç”Ÿå³¶ã•ã‚“ãŒè€ƒãˆã‚‹æœ€å¼·ã®è¨€èªž SQL - ãã‚‹ãã‚‹ï½ž
ç”Ÿå³¶ã•ã‚“ãŒèª°ã¨é—˜ã£ã¦ã„ã‚‹ã®ã‹çŸ¥ã‚‰ãªã„ã‘ã©ã€ã¡ã‚‡ã£ã¨æ°—ã«ãªã‚‹ã“ã¨ã‚’ã¤ã‚‰ã¤ã‚‰ã¨ã€‚ SQLã¯æœ€ã‚‚é«˜ç´šè¨€èªž - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®æ—¥è¨˜ SQLã¯æœ€ã‚‚é«˜ç´šè¨€èªžï¼’ - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®æ—¥è¨˜ SQLã¨ã¯ãªã‚“ãžã‚„ï¼Ÿ - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®æ—¥è¨˜ é«˜ç´š*è¨€èªž* ã©ã†ã‚‚ç”Ÿå³¶ã•ã‚“ã¯ã€ã€ŒSQL ã¯é«˜ç´šè¨€èªžï¼ã€ã¨è¨€ã„ã¤ã¤ SQL ã®å‡¦ç†ç³» (RDBMS) ã®ã“ã¨ã‚’é«˜ç´šã ã¨è¨€ã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ è¨€èªžãŒé«˜ç´šã§ã‚ã‚‹ã“ã¨ã¨ã€å‡¦ç†ç³»ã®æœ€é©åŒ–ãŒæ‰‹åŽšã„ã“ã¨ã‚’ã”ã¡ã‚ƒã¾ãœã«ã—ã¦ã€ã“ã®è¨€èªžé«˜ç´šï¼ã¨è¨€ã†ã®ã¯ã¾ãšã„ã‚“ã˜ã‚ƒãªã„ã§ã—ã‚‡ã†ã‹ã€‚åˆ¥ã«ã€RDBMS ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®è¨€èªžã¨ã—ã¦ SQL ã§ãªããŸã£ã¦ã„ã„ã®ã§ã™ã€‚ä¾‹ãˆã° Tutorial D/Industorial D ã‚‚ã‚ã‚‹ã—ã€LINQ ã‚’ SQL ã«å¤‰æ›ã›ãšã«ç›´æŽ¥ DB ã®æ“ä½œã‚’è¡Œã†ã‚ˆã†ãª RDBMS/Linq to X ã¨è¨€ã†ã®ã‚‚è€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ã“ã“ã§ã¯ã¨ã‚Šã‚ãˆãšã€
Ehren 2010/11/27
sql
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
Ehren 2010/09/17
sql
ãƒªãƒ³ã‚¯
ã¾ã ã¾ã ã‚ã‚‹ãžï¼ åˆ†æžé–¢æ•°ã®ç©¶æ¥µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ ä»Šå›žã‚‚ã€å‰å›žã€ŒSQLåˆ†æžé–¢æ•°ã‚’ã•ã‚‰ã«æ·±ãè¿½æ±‚ã—ã¦ã¿ã‚ˆã†ã€ã€å‰ã€…å›žã€Œæ¥µã‚ã‚ˆã†ï¼åˆ†æžé–¢æ•°ã«ã‚ˆã‚‹SQLé«˜é€ŸåŒ–è¨ˆç”»ã€ã«å¼•ãç¶šãã€åˆ†æžé–¢æ•°ã«ã¤ã„ã¦ã®ãŠè©±ã§ã™ã€‚ä»Šå›žã¯ã€ãƒ©ã‚°ãƒ»ãƒªãƒ¼ãƒ‰é–¢æ•°ã‚’èª¬æ˜Žã—ã¦ã€åˆ†æžé–¢æ•°ã‚·ãƒªãƒ¼ã‚ºã®æœ€çµ‚å›žã¨ã—ã¾ã™ã€‚ ãƒ©ã‚°é–¢æ•°ã‚’ä½¿ã£ãŸåˆ†æž ãã‚Œã§ã¯ã€ãƒ©ã‚°ãƒ»ãƒªãƒ¼ãƒ‰é–¢æ•°ã‚’åˆ©ç”¨ã—ã¦ã€åˆ†æžã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ã¾ãšã¯ã€ãƒ©ã‚°é–¢æ•°ã‹ã‚‰è¦‹ã¦ã„ãã¾ã™ã€‚ ãƒ©ã‚°é–¢æ•°ã¯ã€ç¾åœ¨ã®è¡Œã‹ã‚‰ã®ã‚ªãƒ•ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã™ã‚‹ã ã‘ã§ã€ãã®ä½ç½®ã‚ˆã‚Šã€Œå‰ã€ã«ã‚
Ehren 2010/08/04
oracle

sql
ãƒªãƒ³ã‚¯
SQLåˆ†æžé–¢æ•°ã‚’ã•ã‚‰ã«æ·±ãè¿½æ±‚ã—ã¦ã¿ã‚ˆã†
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ ä»Šå›žã‚‚ã€å‰å›žã€Œæ¥µã‚ã‚ˆã†ï¼åˆ†æžé–¢æ•°ã«ã‚ˆã‚‹SQLé«˜é€ŸåŒ–è¨ˆç”»ã€ã«å¼•ãç¶šãã€åˆ†æžé–¢æ•°ã®ä¸ã‹ã‚‰ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã¨ãƒ¬ãƒãƒ¼ãƒˆé–¢æ•°ã‚’å–ã‚Šä¸Šã’ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã‚’ä½¿ã£ãŸåˆ†æž ãã‚Œã§ã¯ã€ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã‚’åˆ©ç”¨ã—ã¦ã€åˆ†æžã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã‚’ä½¿ç”¨ã—ã¦ã€ç´¯ç©é›†è¨ˆã€ç§»å‹•é›†è¨ˆã€é›†ä¸é›†è¨ˆã‚’è¨ˆç®—ã§ãã¾ã™ã€‚ä»Šå›žã¯ã€ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã‚’ç°¡å˜ã«ç†è§£ã—ã¦ã‚‚ã‚‰ã†ãŸã‚ã«ã€ç´¯ç©é›†è¨ˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã«ã¯ã€SUM()ã€AVG
Ehren 2010/08/04
oracle

sql
ãƒªãƒ³ã‚¯
ï¼ ITï¼šSQLã‚¯ãƒªãƒ‹ãƒƒã‚¯ï¼ˆ8ï¼‰ã€€Page 1/3
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ ä»Šå›žã¯Oracle8iï¼ˆãƒªãƒªãƒ¼ã‚¹8.1.6ï¼‰ã‹ã‚‰å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹åˆ†æžé–¢æ•°ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚åˆ†æžæ©Ÿèƒ½ã‚’ç†è§£ã—ã¦ãŠãã¨ã€ã„ã¾ã¾ã§ã¯å‰¯å•ã„åˆã‚ã›ã‚„è¤‡æ•°å›žã«åˆ†ã‘ã¦ã„ãŸå•ã„åˆã‚ã›ã‚’1å›žã®SQLæ–‡ã§ç°¡å˜ã«è¡Œãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ åˆ†æžé–¢æ•°ã®åŸºæœ¬ã‚’ç†è§£ã—ã‚ˆã† ã¾ãšã€åˆ†æžé–¢æ•°ã¨ã¯ã€ã©ã®ã‚ˆã†ãªé–¢æ•°ã§ã‚ã‚‹ã®ã‹ã‚’ç°¡å˜ã«èª¬æ˜Žã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ é›†è¨ˆé–¢æ•°ã¨åˆ†æžé–¢æ•°ã®é•ã„ã¯ï¼Ÿ åˆ†æžé–¢æ•°ã¯ã€ã©ã®ã‚ˆã†ã«å‡¦ç†ã•ã‚Œã‚‹ã®ï¼Ÿ åˆ†æžé–¢æ•°ã¯ã€ã©ã®ã‚ˆã†ãªåˆ†
Ehren 2010/08/04
sql
ãƒªãƒ³ã‚¯
SQL*Plus Guide Book
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ä¸€åº¦ã«å–ã‚Šå‡ºã™ãƒ‡ãƒ¼ã‚¿åˆ—ã®æ•°ï¼ˆãƒãƒƒãƒï¼‰ã‚’è¨å®šã™ã‚‹ã€‚1ã€œ5000ã®å€¤ã‚’è¨å®šã§ãã‚‹ã€‚å¤§ãã„å€¤ã‚’è¨å®šã™ã‚‹ã¨ã€å•åˆã›ã‚„å‰¯å•åˆã›ã®åŠ¹çŽ‡ãŒä¸ŠãŒã‚Šã€å¤šãã®ãƒ‡ãƒ¼ã‚¿åˆ—ã‚’å–ã‚Šå‡ºã™ã“ã¨ãŒã§ãã‚‹ãŒã€ãã®å ´åˆã¯ãƒ¡ãƒ¢ãƒªãƒ¼å®¹é‡ãŒå¤§ãããªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ãªãŠã€å€¤ãŒã»ã¼100ä»¥ä¸Šã«ãªã‚‹ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¯ã»ã¨ã‚“ã©å·®ãŒãªããªã‚‹ã€‚ARRAYSIZEã¯SQL*Plusã®å‹•ä½œçµæžœã«ã¯ã¾ã£ãŸãå½±éŸ¿ã›ãšã€å˜ã«åŠ¹çŽ‡ã‚’é«˜ã‚ã‚‹ã ã‘ã®æ©Ÿèƒ½ã§ã‚ã‚‹ã€‚ ï¼»è£œè¶³] ç¾åœ¨ã®ãƒžã‚·ãƒ³ã§ã®èƒ½åŠ›ã§ã¯ç‰¹ã«å¿…è¦ã¯ãªã„ãŒã€ãƒ‡ãƒ¼ã‚¿é‡ãŒå¤šã„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ“ä½œã™ã‚‹ã¨ããƒ¡ãƒ¢ãƒª ä¸è¶³ã«ãªã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ãã®å ´åˆã€å‡¦ç†ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒå¤šå°‘çŠ ç‰²ã«ãªã‚‹ãŒæ£å¸¸ã«å®Ÿè¡Œã•ã›ã‚‹ãŸã‚ã« ã€Œset array 2ã€ã‚’æŒ‡å®šã™ã‚‹ã¨ã‚ˆã„ã€‚ Oracleã«ãŠã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ä¿ç•™ä¸ã®å¤‰æ›´ã‚’ã‚³ãƒŸãƒƒãƒˆã™ã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’åˆ¶å¾¡ã™ã‚‹ã€‚ ONã«ã™ã‚‹ã¨ã€INSERTã€UPDATEã€DELETEã‚³ãƒžãƒ³
Ehren 2010/08/02
oracle

sql
ãƒªãƒ³ã‚¯
OTN Japan - 404 Error
Ehren 2010/08/02
oracle

sql
ãƒªãƒ³ã‚¯
WHENEVER SQLERROR - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL*Plus ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
SQLã€PL/SQL ãƒ¬ãƒ™ãƒ«ã®ã‚¨ãƒ©ãƒ¼ãƒãƒ³ãƒ‰ãƒ« WHENEVER SQL ERROR ã¯ã‚³ãƒžãƒ³ãƒ‰ã®å®Ÿè¡Œå‰ã« SQL ã‚³ãƒžãƒ³ãƒ‰ã‚„ PL/SQL ãƒ–ãƒãƒƒã‚¯ãƒ¬ãƒ™ãƒ«ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ãŸå ´åˆã®å‡¦ç†ã‚’äº‹å‰ã«å®šç¾©ã—ã¦ãŠããŸã‚ã®ã‚³ãƒžãƒ³ãƒ‰ çŸç¸®å½¢ ãªã— ä¾‹ãˆã° UPDATE not_exists_table_name SET ...ã§æŒ‡å®šã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ãŒå˜åœ¨ã—ãªã„å ´åˆã«ç™ºç”Ÿã™ã‚‹ã€‚ WHENEVER SQL ERROR ã‚³ãƒžãƒ³ãƒ‰ WHENEVER SQL ERROR ã‚³ãƒžãƒ³ãƒ‰ã®æ§‹æ–‡ EXITï¼ˆçµ‚äº†ï¼‰ã™ã‚‹å ´åˆ WHENEVER SQL ERROR EXIT [ SUCCESS | FAILURE | WARNING | æˆ»ã‚Šå€¤(â€»1)] [ COMMIT | ROLLBACK ] CONTINUEï¼ˆç¶™ç¶šï¼‰ã™ã‚‹å ´åˆ WHENEVER SQL ERROR CONTINUE [ COMMIT | ROLLBACK | NONE ]
Ehren 2010/08/02
oracle

sql
ãƒªãƒ³ã‚¯
SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ä¸€è¦§ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL*Plus ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã¨ã¯ SQL*Plus ã®å®Ÿè¡Œæ™‚ã®å¼•æ•°ã ã‘ã§ã¯è¨å®šã—ãã‚Œãªã„ã‚‚ã®ã‚„å‹•çš„ã«è¨å®šã‚’å¤‰æ›´ã™ã‚‹ãŸã‚ã«ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’éšæ™‚å¤‰æ›´å¯èƒ½ãªå¤‰æ•°ã€ã«ã—ãŸã‚ˆã†ãªã‚‚ã®ã§ã‚ã‚‹ã€‚ ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®è¨å®šã¯ SQL*Plus ã‚³ãƒžãƒ³ãƒ‰ã® SET ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° å€¤ ã¨ã„ã†å½¢å¼ã§è¡Œãªã„ã€‚ ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®ç¾åœ¨ã®å€¤ã‚’å‚ç…§ã—ãŸã„å ´åˆã«ã¯ SHOW ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° ã‚’å®Ÿè¡Œã™ã‚‹ã¨ç¢ºèªã§ãã‚‹ã€‚ SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ä¸€è¦§
Ehren 2010/08/02
oracle

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