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

kattton id:kattton

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

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

MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã¯rows_examinedã§åˆ¤æ–ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ä»•äº‹ã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã§MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã€EXPLAINã®å†…å®¹ã ã‘ã ã¨ã©ã®ãã‚‰ã„è‰¯ããªã£ãŸã‚Šæ‚ªããªã£ãŸã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ SET long_query_time = 0; ã—ã¦rows_examined (ãã®ã‚¯ã‚¨ãƒªã§rows_sentè¡Œã®çµæžœã‚’è¿”ã™ãŸã‚ã«ä½•è¡Œã«è§¦ã£ãŸã®ã‹)ã‚‚ä¸€ç·’ã«æç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹(å°‘ãªãã¨ã‚‚MySQL 5.7æ™‚ç‚¹ã§ã¯rows_examinedã¯slow_query_logã§ã—ã‹ç¢ºèªã§ããªã„ã¯ãšperformance_schemaãŒæœ‰åŠ¹ãªã‚‰events_statements_historyã‚„ãã®ä»²é–“ãŸã¡ã§ç¢ºèªã§ãã‚‹ã¨ã®ã“ã¨*1 MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 22.9.6 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¤ãƒ™ãƒ³ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«)ã€‚ ä¾‹: ä¸Šã®ä¾‹ã®Beforeã¯ã€ã‚‚ã¨ã‚‚ã¨DBAãŒæ›¸ã„ãŸæ¸©ã‹ã¿ã®ã‚ã‚‹SQLã§O
kattton 2021/04/13
mysql

sql

database
ãƒªãƒ³ã‚¯
MySQL æ—¥æ™‚ã”ã¨ã®é›†è¨ˆã¾ã¨ã‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? æœˆåˆ¥ã€æ—¥åˆ¥ã€æ™‚é–“åˆ¥ã«ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’é›†è¨ˆ ä¸€æœˆæ¯Ž mysql> SELECT DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y-%m') AS time, COUNT(*) AS count FROM ãƒ†ãƒ¼ãƒ–ãƒ«å GROUP BY DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y%m'); ä¸€æ—¥æ¯Ž mysql> SELECT DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y-%m-%d') AS time, COUNT(*) AS count FROM ãƒ†ãƒ¼ãƒ–ãƒ«å GROUP BY DATE_FORMAT(ã‚«ãƒ©ãƒ ï¼‘, '%Y%m%d'); ä¸€æ™‚é–“æ¯Ž mysq
kattton 2015/08/13
sql

qiita
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
æœ¬æ›¸ã¯DBè¨è¨ˆã‚„SQLè¨˜è¿°ã®éš›ã«é¿ã‘ã‚‹ã¹ãäº‹æŸ„ã‚’1ç« ã§1ã¤ã€25å€‹ç´¹ä»‹ã™ã‚‹æ›¸ç±ã§ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸å¿ƒã«æ®ãˆãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«ã¯ã€æ§˜ã€…ãªå ´é¢ã§é™¥ã‚Šã‚„ã™ã„å¤±æ•—ï¼ˆã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ›¸ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–ç†è¨è¨ˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰©ç†è¨è¨ˆã€ã‚¯ã‚¨ãƒªã®è¨˜è¿°ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã¨ã„ã†4ã¤ã®ã‚«ãƒ†ã‚´ãƒªã«åˆ†ã‘ã€ãã‚Œãžã‚Œã®åˆ†é‡Žã«ãŠã‘ã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç´¹ä»‹ã—ã€å¤±æ•—ã‚’é¿ã‘ã‚‹ãŸã‚ã®ã‚ˆã‚Šè‰¯ã„æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚è¤‡æ•°ã®å€¤ã‚’æŒã¤å±žæ€§ã‚„å†å¸°çš„ãªãƒ„ãƒªãƒ¼æ§‹é€ ã®æ ¼ç´ã‹ã‚‰ã€å°æ•°å€¤ã®ä¸¸ã‚ã‚„NULLã®æ‰±ã„ã«èµ·å› ã™ã‚‹å•é¡Œã€å…¨æ–‡æ¤œç´¢ã‚„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€MVCã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã©ã€å®Ÿè·µçš„ã‹ã¤å¹…åºƒã„ãƒˆãƒ”ãƒƒã‚¯ã‚’ç¶²ç¾…ã—ã¾ã™ã€‚æ—¥æœ¬èªžç‰ˆã§ã¯ã€MySQLã®ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦è‘—åãªå¥¥é‡Žå¹¹ä¹Ÿæ°ã«ã‚ˆã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’åŽéŒ²ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã‚ã‚‹ã™ã¹ã¦ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®ä¸€å†Šã§ã™ã€‚ æœ¬æ›¸ã¸ã®ç§°è³›ã®å£° ç›£è¨³è€…ã¾ãˆãŒã ã¯ã˜ã‚ã« Iéƒ¨ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–
kattton 2013/04/20
#devsumi Ebookã§è³¼å…¥ã€‚ã™ãã«Kindleã§èªã‚ã‚‹ã®ãŒã„ã„ãï¼

sql

oreilly
ãƒªãƒ³ã‚¯
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•.markdown #NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³• åŽŸæ–‡ï¼šNoSQL Data Modeling Techniques Â« Highly Scala ble Blog I translated this article for study. contact matope[dot]ono[gmail] if any probl em. NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ä¸€è²«æ€§ã¨ã„ã£ãŸæ§˜ã€…ãªéžæ©Ÿèƒ½è¦ä»¶ã‹ã‚‰æ¯”è¼ƒã•ã‚Œã‚‹ã€‚NoSQLã®ã“ã®å´é¢ã¯å®Ÿè·µã¨ç†è«–ã®ä¸¡é¢ã‹ã‚‰ã‚ˆãç ”ç©¶ã•ã‚Œã¦ã„ã‚‹ã€‚ã‚ã‚‹ç¨®ã®éžæ©Ÿèƒ½ç‰¹æ€§ã¯NoSQLã‚’åˆ©ç”¨ã™ã‚‹ä¸»ãªå‹•æ©Ÿã§ã‚ã‚Šã€NoSQLã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆãé©ç”¨ã•ã‚Œã‚‹CAPå®šç†ãŒãã†ã§ã‚ã‚‹ã‚ˆã†ã«åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã®åŸºæœ¬çš„åŽŸå‰‡ã ã‹ã‚‰ã ã€‚ä¸€æ–¹ã§ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯ã‚ã¾ã‚Šç ”ç©¶ã•ã‚Œã¦ãŠã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒžãƒ†ã‚£ãƒƒã‚¯
kattton 2012/04/17
ã‚ã¨ã§èªã‚€ã‹ã‚‚ã—ã‚Œãªã„

nosql

programming

db

sql
ãƒªãƒ³ã‚¯
New Releases: 2.3.11 and 3.0.4
Two new versions of Ruby On Rails have been released today. As well as including a number of bugfixes they contain fixes for some security issues. The full details of each of the vulnerabilities are available on the rubyonrails-security mailing list. We strongly urge you to update production Rails applications as soon as possible. Rather than post the advisories individually to this blog, Iâ€™ll jus
kattton 2011/02/09
rails 3.0.4 !!

rails

sql

security

xss
ãƒªãƒ³ã‚¯
ActiveRecordã§ã®distinctã«ã¤ã„ã¦ - blog.takuyan.com
ã‚ã‚‹Modelã‹ã‚‰ã€ user.idã§æŠ½å‡ºã—ã€ field_nameã§Distinctã—ãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã€ created_atã®é™é †ã§ã€ 5ã¤æ¬²ã—ã‹ã£ãŸ ã®ã§ã€ä»¥ä¸‹ã®ã‚ˆã†ã«å®Ÿè£…ã—ã¦ã¿ãŸã€‚ models = SomeModel.find(:all, :select => "distinct field_name", :limit => 5, :order => "created_at desc", :conditions => ["user_id = ?", user.id]) ãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒ(MySQL)ã§ã¯ã€ã“ã„ã¤ã§ã‚‚ã¾ã‚è‰¯ã‹ã£ãŸã®ã ãŒã€ å…¬ç§å…±ã«ãŠä¸–è©±ã«ãªã£ã¦ã„ã‚‹Herokuã§ã¯Postgresqlã‚’ä½¿ã£ã¦ã„ã‚‹æ§˜åã§ã€ Distinct ã®æ–‡æ³•ãŒè‹¥å¹²ç•°ãªã‚‹ã®ã§ã‚¨ãƒ©ãƒ¼ã‚’å‡ºã•ã‚ŒãŸã€‚ ãªã‚“ã§ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã—ã¦è§£æ±ºã—ãŸã€‚ if connection.supports_count_distinct?
kattton 2009/07/28
ruby

rails

sql
ãƒªãƒ³ã‚¯
URLã‚’æ‰±ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã¨ãã«ã©ã†ã™ã¹ãã‹ - é‡‘åˆ©0ç„¡åˆ©æ¯ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚° â€“ ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ãã¾ã™ - subtech
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
kattton 2009/03/27
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

è¨è¨ˆ

mysql

sql

tips

db
ãƒªãƒ³ã‚¯
WWW SQL Designer
* * * * * * *
kattton 2009/03/11
ERå›³ä½œæˆã«æœ€é©ã€‚Railsã ã¨Modelã‚‚ã“ã‚Œã§ã„ã‘ã‚‹ã€‚å¤§æ¦‚ã¯ã€‚

webã‚µãƒ¼ãƒ“ã‚¹

sql

design

database

db

er
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
kattton 2009/01/26
ã“ã‚Œã¯ã™ã”ã„

ãƒ„ãƒ¼ãƒ«

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

é–‹ç™º

sql

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

æŠ€è¡“

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ã“ã‚Œã¯å®Ÿç”¨çš„

sql

tips

database
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆSYS_CONNECT_BY_PATHï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ çµ„ç¹”ã®éšŽå±¤æ§‹é€ ã‚’å‡ºåŠ›ã™ã‚‹ã«ã¯ã€SYS_CONNECT_BY_PATHé–¢æ•°ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ SELECT SYS_CONNECT_BY_PATHï¼ˆ é …ç›®, åŒºåˆ‡ã‚Šæ–‡å— ï¼‰ FROM è¡¨ STRAT WITH ãƒ«ãƒ¼ãƒˆéšŽå±¤ CONNECT BY PRIOR åãƒ¬ã‚³ãƒ¼ãƒ‰é …ç›® = è¦ªãƒ¬ã‚³ãƒ¼ãƒ‰é …ç›®; SYS_CONNECT_BY_PATHé–¢æ•°ã®ç¬¬ä¸€å¼•æ•°ã§ã€éšŽå±¤æ§‹é€ ã‚’å‡ºåŠ›ã™ã‚‹é …ç›®åã‚’ã€ç¬¬äºŒå¼•æ•°ã§éšŽå±¤ã‚’åŒºåˆ‡ã‚‹åŒºåˆ‡ã‚Šæ–‡å—ã‚’æŒ‡å®šã—ã¾ã™ã€‚ STRAT WITHå¥ã§ã¯ã€æœ€ä¸Šä½éšŽå±¤ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¾ã™ã€‚ CONNECT BY PRIORå¥ã§ã¯ã€ä¸Šä½éšŽå±¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ã®é–¢é€£ä»˜ã‘ã‚‹é …ç›®ã‚’æŒ‡å®šã—ã¾ã™ã€‚
kattton 2008/09/29
SQL

CONNECT BY

ORACLE

oracle

é–¢æ•°
ãƒªãƒ³ã‚¯
ï¼ ITï¼šOracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¬›åº§ï¼ˆ5ï¼‰ SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç›¤ã¨ãªã‚‹çµ±è¨ˆæƒ…å ±
æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚èªè€…ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’åŸºæœ¬ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ é€£è¼‰ç›®æ¬¡ å‰å›žã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒå¿…è¦ãªSQLã‚’æ´—ã„å‡ºã™ã€ã§ã¯ã€å‹•çš„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ç”¨ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å¯¾è±¡ã¨ãªã‚Šå¾—ã‚‹SQLã‚’æ´—ã„å‡ºã™æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸãŒã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ãŸã‚ã«ã¯ã€SQLã®å®Ÿè¡Œè¨ˆç”»ãªã©ã€ã‚ˆã‚Šè©³ç´°ãªæƒ…å ±ãŒå¿…è¦ã¨ãªã‚Šã¾ã™ã€‚ä»Šå›žã¯ã€ã“ã‚Œã‚‰ã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã€ã¾ãŸåŽé›†ã—ãŸæƒ…å ±ã®åˆ†æžæ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚ SQLè©³ç´°æƒ…å ±ã®å–å¾— SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†éš›ã«é‡è¦ã¨ãªã‚‹æƒ…å ±ã¨ã—ã¦ã¯ã€SQLã®
kattton 2008/03/17
oracle

database

sql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1