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

Ehren id:Ehren

oracleã«é–¢ã™ã‚‹Ehrenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (36)

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

Oracle vs Googleè¨´è¨Ÿã®æ¦‚è¦
2. TechVisor.JP è‡ªå·±ç´¹ä»‹ ï® æ—¥æœ¬IBMã§SEã‚’14å¹´ã€ã‚¬ãƒ¼ãƒˆãƒŠãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ã§ITæ¥ç•Œã‚¢ãƒŠãƒªã‚¹ãƒˆã‚’ 10å¹´çµŒé¨“ã®å¾Œã€å¼ç†å£«å…¼IT ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã¨ã—ã¦ç‹¬ç«‹ï¼ˆ11å¹´ç›®ï¼‰ ï® æœ€è¿‘ã®ä¸»ãªæ¥å‹™å†…å®¹ ï¬ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºä¼šç¤¾/ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ä¼æ¥å‘ã‘ã®çŸ¥è²¡ã‚³ãƒ³ã‚µãƒ« ãƒ†ã‚£ãƒ³ã‚°ã€ç‰¹è¨±å‡ºé¡˜ä»£ç† ï¬ å•†æ¨™ç™»éŒ²å‡ºé¡˜ä»£ç† ï¬ VCå‘ã‘ã®ç‰¹è¨±èª¿æŸ»ï¼çŸ¥è²¡ãƒ‡ãƒ¥ãƒ¼ãƒ‡ãƒªã‚¸ã‚§ãƒ³ã‚¹ ï¬ ç‰¹è¨±è¨´è¨Ÿäº‹ä»¶ã®è£æ–¹æ”¯æ´ ï® ã€ŒYahoo!ãƒ‹ãƒ¥ãƒ¼ã‚¹å€‹äººã€ã‚’ä¸å¿ƒã«æƒ…å ±ç™ºä¿¡ ï® é‡‘æ²¢å·¥æ¥å¤§å¦å¤§å¦é™¢ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆç ”ç©¶ç§‘å®¢å“¡æ•™æŽˆ ï® æ±äº¬å¤§å¦å·¥å¦éƒ¨å’ã€MITè¨ˆç®—æ©Ÿç§‘å¦ç§‘ä¿®å£«èª²ç¨‹ä¿®äº† 216/07/11 3. TechVisor.JP ä¸»ãªè¨³æ›¸ 16/07/11 3 ã€Œãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ« ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã€ ã‚¸ã‚§ãƒ•ãƒªãƒ¼ãƒ»ãƒ ãƒ¼ã‚¢è‘— â€¢ ãƒ“ã‚¸ãƒã‚¹æ›¸ã®å¤å…¸çš„åè‘—ã€Œã‚ãƒ£ã‚ºãƒ ã€ã®è‘—è€…ã«ã‚ˆã‚‹ã€ä¼æ¥ãŒã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç¶™ç¶š çš„ã«è¡Œãªã£ã¦ã„ããŸã‚
Ehren 2016/07/12
java

oracle

google
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ãŒJavaã‚¨ãƒ´ã‚¡ãƒ³ã‚¸ã‚§ãƒªã‚¹ãƒˆã‚’å‰Šæ¸›
Spring Bootã«ã‚ˆã‚‹APIãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰æ§‹ç¯‰å®Ÿè·µã‚¬ã‚¤ãƒ‰ ç¬¬2ç‰ˆ ä½•åƒäººã‚‚ã®é–‹ç™ºè€…ãŒã€InfoQã®ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ŒPractical Guide to Building an API Back End with Spring Bootã€ã‹ã‚‰ã€Spring Bootã‚’ä½¿ã£ãŸREST APIæ§‹ç¯‰ã®åŸºç¤Žã‚’å¦ã‚“ã ã€‚ã“ã®æœ¬ã§ã¯ã€å‡ºç‰ˆæ™‚ã«æ–°ã—ããƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Spring Boot 2 ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€Spring Boot3ãŒæœ€è¿‘ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€é‡è¦ãªå¤‰...
Ehren 2015/09/15
java

oracle
ãƒªãƒ³ã‚¯
Oracle cuts Java staff
It looks like Oracle is paring back its Java team. There were reports last week on Twitter and Reddit, picked up by Infoworld, that top Java evangelists have left the database giant. Cameron Purdy, a senior vice president for development and a noted Java evangelist, left Oracle (ORCL) in August after more than 8 years at the company, according to his LinkedIn bio. In a few tweets, he indicated tha
Ehren 2015/09/10
java

oracle

google
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ãŒã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã®è²·åŽã‚’å®Œäº†ã—ã€ã¡ã‚‡ã†ã©5å¹´
ä»Šå›žã®ã“ã¨ã° ã€ŒEngineered Systemã¯ã€ãƒãƒ¼ãƒ‰ã¨ã‚½ãƒ•ãƒˆã®æŠ±ãåˆã‚ã›ã§ã¯ãªã„ã€‚ä»æ•™ç”¨èªžã§ã„ãˆã°ç„¡åˆ†åˆ¥æ™ºã®çŠ¶æ³ã€ ï¼ˆæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ãƒ»æ‰åŽŸåšèŒ‚ç¤¾é•·ï¼‰ 2010å¹´1æœˆ27æ—¥ã¯ã€ã‚ªãƒ©ã‚¯ãƒ«ãŒã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã®è²·åŽã‚’å®Œäº†ã—ãŸæ—¥ã ã€‚ä»Šå¹´ã¯ãã‚Œã‹ã‚‰ã¡ã‚‡ã†ã©5å¹´ã‚’è¿ŽãˆãŸã€‚ æ˜¨å¹´4æœˆã«æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®å–ç· å½¹ä»£è¡¨åŸ·è¡Œå½¹ç¤¾é•·å…¼CEOã«å°±ä»»ã—ãŸæ‰åŽŸåšèŒ‚æ°ã¯ã€ã€Œç¤¾é•·ã«å°±ä»»ã—ã¦10ã‚«æœˆã‚’çµŒéŽã—ã¦ã‚ã‹ã£ãŸã®ã¯ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’è²·åŽä»¥é™ã€ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«Engineered Systemã‚„SPARCã¨ã„ã£ãŸãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚’æŠ±ãåˆã‚ã›ã§å£²ã‚‹ã®ã§ã¯ãªã„ã‹ã¨ã€é•·å¹´è¨€ã‚ã‚Œç¶šã‘ã¦ããŸã“ã¨ã€‚ã ãŒã€ãã†ã§ã¯ãªã„ã€‚ä»æ•™ç”¨èªžã§ã„ãˆã°ã€ç„¡åˆ†åˆ¥æ™ºã®ä¸–ç•Œã«å…¥ã£ã¦ããŸã€ã¨èªžã‚‹ã€‚ ã„ããªã‚Šã®ä»æ•™ç”¨èªžã®èžããªã‚Œãªã„è¨€è‘‰ã«é©šã„ãŸãŒã€ç„¡åˆ†åˆ¥æ™ºã¨ã¯ã€ç‰©äº‹ã‚’åˆ†ã‘ã¦æ‰ãˆã‚‹åˆ†åˆ¥çŸ¥ã‚’ã€ç©¶æ¥µã¾ã§çªãè©°ã‚ã¦ã„ãã¨ã€åˆ†åˆ¥ã®æœ¬è³ªã‚’ç†è§£ã—ãŸã†
Ehren 2015/02/05
oracle

java
ãƒªãƒ³ã‚¯
BLOG.IK.AM
Ehren 2013/07/24
coherence

oracle
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2012/08/21/20120818oracle-makes-more-moves-to-kill-open-source-mysql/
Ehren 2012/08/21
oracle

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

sql
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
Ehren 2011/08/16
oracle
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/entry/post_85
Ehren 2011/06/28
oracle

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

RDBMS
ãƒªãƒ³ã‚¯
OTN Japan - 404 Error
Ehren 2011/05/30
oracle
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/column/technical/026790.html
Ehren 2011/04/26
RDBMS

oracle
ãƒªãƒ³ã‚¯
Oracleã§AutoIncrement - niwanosã®æ—¥è¨˜
MySQLã®ã‚ˆã†ã«autoincrementã‚’Oracleã§ä½¿ã„ãŸã„ã“ã¨ãŒå¤šã€…ã‚ã‚Šã¾ã™ãŒ Oracleã«ã¯autoincrementã«ç›¸å½“ã™ã‚‹æ©Ÿèƒ½ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ Oracleã§åŒç‰ã®ã“ã¨ã‚’ã—ãŸã„ã¨ãã¯DMLTriggerã‚’é§†ä½¿ã—ã¾ã™ã€‚ ãŸã¨ãˆã° ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ«ã¨ CREATE TABLE TEST_USER ( ID NUMBER NOT NULL, NAME VARCHAR2(200), CONSTRAINT PK_TEST_USER PRIMARY KEY (ID) ); ã“ã‚“ãªã‚·ãƒ¼ã‚±ãƒ³ã‚¹ãŒ CREATE SEQUENCE SEQ_TEST_USER INCREMENT BY 1 START WITH 1; ã‚ã£ãŸã‚‰ ã“ã‚“ãªãƒˆãƒªã‚¬ãƒ¼ã‚’ã¤ãã‚Šã¾ã™ã€‚ CREATE OR REPLACE TRIGGER TRG_TEST_USER BEFORE INSERT ON TEST_USER FOR
Ehren 2011/04/21
oracle
ãƒªãƒ³ã‚¯
æ´¥å³¶åšå£«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¬›åº§ã€€ç¬¬6å›žã€€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®åŸºç¤Žã§ã‚ã‚‹ç´¢å¼•ã«ã¤ã„ã¦ | oracletech.jp
ä»Šå›žã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ä¸€ç•ªå½±éŸ¿ã™ã‚‹ç´¢å¼•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã™ã‚‹ãŸã‚ã«ã¯åŠ¹çŽ‡ã‚ˆã„ç´¢å¼•ã®è¨è¨ˆã‚’è¡Œã£ã¦ä¸‹ã•ã„ã€ã¨è¨€ã‚ã‚Œã¾ã™ãŒã€å…·ä½“çš„ã«ã©ã®ã‚ˆã†ã«è¨è¨ˆã™ã‚Œã°ã‚ˆã„ã‹åˆ†ã‹ã‚‰ãªã„æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ï¼ˆå¤šãä½œæˆã™ã‚Œã°ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã«ãªã‚Šã¾ã™ã—ã€é€†ã«å¿…è¦ãªSQLæ–‡ã§ç´¢å¼•ãŒä½¿ç”¨ã•ã‚Œãªã„ã“ã¨ãŒã‚ã‚Šã¾ã™ã‚ˆãï¼‰ã€‚ãã“ã§ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŽŸç‚¹ã«æˆ»ã£ã¦ç´¢å¼•ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã®ã§ã€å‚è€ƒã«ã—ã¦ä¸‹ã•ã„ã€‚ Oracle Databaseã«ã¯ã€ã„ãã¤ã‹ã®ç´¢å¼•ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ã“ã¡ã‚‰ã‚’æŠ¼ã•ãˆã¦ãŠãã¨ã€ã•ã‚‰ã«ç†è§£ãŒé€²ã‚€ã¨æ€ã„ã¾ã™ã€‚ ã‚ªãƒ©ã‚¯ãƒ«ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é€šä¿¡ï¼šã€ŒOracle Databaseã®ç´¢å¼•ã®ç¨®é¡ž - Bãƒ„ãƒªãƒ¼ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã€ç´¢å¼•æ§‹æˆè¡¨ã€ç´¢å¼•ã‚¯ãƒ©ã‚¹ã‚¿ã€ â– ï¼‘ï¼Žç´¢å¼•ã¨ã¯ å…ˆãšã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ã€Œç´¢å¼•ã¨ã¯ã€ã«ã¤ã„ã¦ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚çš†ã•ã‚“ã¯å½“ç„¶ã”å˜çŸ¥ã‹ã¨æ€ã„ã¾ã™ãŒ
Ehren 2011/04/20
oracle

RDBMS

db
ãƒªãƒ³ã‚¯
ã€ŽOracleã‚ˆã‚Šã‚‚MySQLã®æ–¹ãŒä¾¿åˆ©ã ã¨æ€ã†SQLæ§‹æ–‡æ¯”è¼ƒã€
mysql> select sysdate(); +---------------------+ | sysdate() | +---------------------+ | 2010-08-18 23:11:27 | +---------------------+ 1 row in set (0.00 sec) â– 2. ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ä½œã‚‰ãªãã¦ã„ã„ è¡¨ã®åˆ—ã«auto_incrementå±žæ€§ã‚’ã¤ã‘ã‚‹ã“ã¨ã§ã€insertæ™‚ã«å‹æ‰‹ã«æŽ¡ç•ªã—ã¦ãã‚Œã‚‹ã€‚å˜ã«å›ºæœ‰ã®IDç•ªå·ã‚’æŒ¯ã‚ŠãŸã„æ™‚ã¯ä¾¿åˆ©ã™ãŽã‚‹ã€‚ä½•ã§Oracleã«ã¯ãªã„ã‚“ã ï¼Ÿã£ã¦ãã‚‰ã„ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ä½œã£ã¦ç®¡ç†ã™ã‚‹ã®ã£ã¦çµæ§‹ã‚ã‚“ã©ã†ãã•ã„ã€‚ ãŸã ã€æ€§èƒ½é¢ã§è¨€ã†ã¨ã€ä»•çµ„ã¿çš„ã«ç®¡ç†ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œãƒãƒƒã‚¯ã‚’å–ã£ã¦ã—ã¾ã†ã¯ãšãªã®ã§ã€Oracleã®SEQUENCEã«ã¯å…¨ãæ•µã‚ãªã„ã§ã—ã‚‡ã†ã€‚å¾Œã¯ã€è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã«åŒã˜ç•ªå·ã‚’æŒ¯ã‚ŠãŸã„ã¨ãã‚‚å›°ã‚‹ã€‚ â– 3.ä¸€åˆ—
Ehren 2011/03/04
oracle

mysql
ãƒªãƒ³ã‚¯
Oracle Coherenceå…¥é–€
Oracle Coherenceã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€å¯ç”¨æ€§ã¨ã„ã†3ã¤ã®æ©Ÿèƒ½è¦ä»¶ã‚’åŒæ™‚ã«æº€è¶³ã™ã‚‹ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼ãƒ‡ãƒ¼ã‚¿ã‚°ãƒªãƒƒãƒ‰ã€‚ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã§ãƒã‚¤ãƒ‘ãƒ¼ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¢ãƒ¬ã‚¯ã‚µãƒ³ãƒ€ãƒ¼ãƒ»ã‚»ã‚ªãƒ´ã‚£ã‚¯ï¼ˆAleksandar SeoviÄ‡ï¼‰ã¯S4HCç¤¾ã®å‰µè¨è€…ã§ã€ç¾åœ¨ã¯å–ç· å½¹ã§ã™ã€‚å½¼ã¯ã€S4HCç¤¾ã§ãƒ—ãƒãƒ•ã‚§ãƒƒã‚·ãƒ§ãƒŠãƒ«ã‚µãƒ¼ãƒ“ã‚¹ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’æŒ‡æ®ã—ã¦ã„ã¾ã™ã€‚å½¼ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã€ä¸–ç•Œä¸ã®é¡§å®¢ã®å…ƒã‚’é£›ã³å›žã‚Šã€ãƒ“ã‚¸ãƒã‚¹ä¸Šã€æŠ€è¡“ä¸Šã®è¤‡é›‘ãªå•é¡Œã‚’è§£ããŸã‚ã®è§£æ±ºç–ã®å®Ÿè£…ã«å°½åŠ›ã—ã¦ã„ã¾ã™ã€‚ ãƒžãƒ¼ã‚¯ãƒ»ãƒ•ã‚¡ãƒ«ã‚³ï¼ˆMark Falcoï¼‰ã¯ã€ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ¡ãƒ³ãƒã‚ªãƒ–ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚¹ã‚¿ãƒƒãƒ•ã§ã™ã€‚å½¼ã¯ã€2005å¹´ã‹ã‚‰Coherenceã®é–‹ç™ºãƒ¡ãƒ³ãƒã§ã‚ã‚Šã€ã‚¯ãƒ©ã‚¹ã‚¿ãƒ»ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒãƒˆã‚³ãƒ«ã€C++ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ»ãƒ¢ãƒ‡ãƒ«ã‚’å°‚é–€ã¨ã—ã¦ã„ã¾ã™ã€‚ãƒž
Ehren 2011/01/26
book

oracle

kvs
ãƒªãƒ³ã‚¯
SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã®ã€Œè§£æ±ºã€ã‹ã‚‰ã€Œäºˆé˜²ã€ã¾ã§ã€ã“ã‚Œ1å†Šã§å…¨ã¦ãƒžã‚¹ã‚¿ãƒ¼ï¼ ã€ŒåŸºç¤Žã‹ã‚‰å¦ã¶ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ | oracletech.jp
SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã®ã€Œè§£æ±ºã€ã‹ã‚‰ã€Œäºˆé˜²ã€ã¾ã§ã€ã“ã‚Œ1å†Šã§å…¨ã¦ãƒžã‚¹ã‚¿ãƒ¼ï¼ ã€ŒåŸºç¤Žã‹ã‚‰å¦ã¶ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’çµŒé¨“ã—ãŸã“ã¨ã®ã‚ã‚‹æ–¹ã€…ã®å¤šãã¯ã€ã‚µãƒ¼ãƒ“ã‚¹ã‚¤ãƒ³ã®ç›´å‰ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã«ç›´é¢ã—ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä»Šå›žã”ç´¹ä»‹ã™ã‚‹ã€ŒåŸºç¤Žã‹ã‚‰å¦ã¶ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¯ã€æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã¨ã—ã¦ã€ã“ã‚Œã¾ã§å¤šãã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã«é–¢ã™ã‚‹æ”¯æ´ã‚’è¡Œã£ã¦ããŸåŠ è—¤ç¥¥å¹³æ°ã€ä¸å³¶ç›Šæ¬¡éƒŽæ°ãŒã€SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’ã©ã®ã‚ˆã†ã«è§£æ±ºã—ã€äºˆé˜²ã§ãã‚‹ã‹ã‚’è§£èª¬ã—ãŸæ›¸ç±ã§ã™ã€‚ æœ¬æ›¸ã§ã¯ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã®ç™ºç”Ÿç†ç”±ã‚’æ‰ãˆã‚‹ã€ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’ã€Žè§£æ±ºã€ã™ã‚‹ã€ã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’ã€Žäºˆé˜²ã€ã™ã‚‹ã€ã®3ã¤ã‚’ãƒ†ãƒ¼ãƒžã«ã€Oracleã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ãªãŒã‚‰ã€SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã®è§£æ±ºãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚„ã€ã“ã®
Ehren 2011/01/24
oracle
ãƒªãƒ³ã‚¯
çªç„¶ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ€ã‚¦ãƒ³ã‚’é˜²ããŸã‚ã®ãƒãƒƒãƒå‡¦ç†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)
Ehren 2011/01/03
oracle

RDBMS
ãƒªãƒ³ã‚¯
Oracleå¯¾Googleè£åˆ¤ã¯ã€Androidã¨OSSã®å°†æ¥ã‚’å·¦å³ã™ã‚‹
ç±³OracleãŒç±³Googleã‚’è¨´ãˆã¦ã„ã‚‹è£åˆ¤ã«ã¯æ³¨ç›®ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚Oracleå´ã¯ã€ŒAndroidã¯Javaãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã®çŸ¥çš„æ‰€æœ‰æ¨©ã‚’ä¾µå®³ã—ã¦ã„ã‚‹ã€ã¨ä¸»å¼µã—ã¦ã„ã‚‹ã€‚Googleå´ã¯ã“ã‚Œã‚’å…¨é¢çš„ã«å¦å®šã—ã€ã€Œã“ã®è¨´è¨Ÿã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¸ã®æ”»æ’ƒã ã€ã¨éžé›£ã™ã‚‹ã€‚ä¸¡ç¤¾ã¯å…¨é¢å¯¾æ±ºã®æ§‹ãˆã ã€‚ ã‚‚ã¨ã‚‚ã¨æºå¸¯é›»è©±æ¥ç•Œã§ã¯å¤§æ‰‹ä¼æ¥åŒå£«ã®è¨´è¨Ÿã¯é »ç¹ã«èµ·ãã¦ã„ã‚‹ã€‚Androidã«é–¢ä¿‚ã™ã‚‹è£åˆ¤ã ã‘ã‚’è¦‹ã¦ã‚‚ã€Appleå¯¾HTCï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€Appleå¯¾Motorolaï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã®è£åˆ¤ãŒé€²è¡Œä¸ã ã€‚ ãã†ã—ãŸä¸ã§ãªãœOracleã¨Googleè£åˆ¤ã«æ³¨ç›®ã™ã‚‹ã‹ã¨ã„ãˆã°ã€ç¬¬1ã«ã€ŒAndroidé–‹ç™ºã®äº‹å®Ÿä¸Šã®æœ¬ä¸¸ã€ã§ã‚ã‚‹GoogleãŒç›´æŽ¥ã®æ¨™çš„ã¨ãªã‚‹å¤§åž‹è¨´è¨Ÿã§ã‚ã‚‹ã‹ã‚‰ã ã€‚ç¬¬2ã«ã€è¨´è¨Ÿã®çµŒç·¯ã«ã‚ˆã£ã¦ã¯Google 1ç¤¾ã«ã¨ã©ã¾ã‚‰ãšã€ä»–ã®Androidã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚’é–‹ç™ºè£½é€ ã™ã‚‹ãƒ¡ãƒ¼ã‚«ãƒ¼ã«ã‚‚å½±éŸ¿ãŒãŠã‚ˆã¶å¯èƒ½æ€§ãŒã‚ã‚‹ã‹ã‚‰ã ã€‚
Ehren 2010/11/08
OSS

oracle

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