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

doboccho id:doboccho

SQLã«é–¢ã™ã‚‹dobocchoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
doboccho 2015/08/23
SQL
ãƒªãƒ³ã‚¯
APPEND_VALUESã®é–“é•ã£ãŸä½¿ã„æ–¹ã‚’ã—ã¦ã¿ã‚‹ - kagamihogeã®æ—¥è¨˜
Oracleã«ã¯ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã¨ã„ã†INSERTã‚’é«˜é€Ÿã«è¡Œã†æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ãã‚Œã‚’æŒ‡ç¤ºã™ã‚‹ãŸã‚ã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ç”¨ã®ãƒ’ãƒ³ãƒˆã¯2ç¨®é¡žã‚ã‚Šã€APPENDã¨APPEND_VALUESã¨ãŒã‚ã‚‹ã€‚æ–‡æ³•ä¸Šã®é•ã„ã ã‘ã‚’è¦‹ã‚‹ã¨ã€APPENDã¯INSERT ã€œ SELECTã«ä½¿ã†ã‚‚ã®ã§ã€APPEND_VALUESã¯INSERT ã€œ VALUESã«ä½¿ç”¨ã™ã‚‹ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ‘ã‚¹ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã®å‹•ä½œçš„ã«ã€APPENDã¯ä½¿ã†æ©Ÿä¼šã¯ã‚ã£ã¦ã‚‚APPEND_VALUESã¯ã»ã¨ã‚“ã©ç„¡ã„ã¨æ€ã‚ã‚Œã‚‹ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ç†å±ˆã®ä¸Šã§ã¯ç„¡é§„ï¼ˆã‚€ã—ã‚é‚ªæ‚ªï¼‰ãªçµæžœã«ãªã‚‹ã“ã¨ã‚’ã‚ãˆã¦è©¦ã™ã€‚å…·ä½“çš„ã«ã¯ã€ä¸‹è¨˜ã®ã‚ˆã†ãªINSERTæ–‡ã‚’10ä¸‡å›žã»ã©ç™ºè¡Œã—ãŸã¨ãã€ä½•ãŒèµ·ãã‚‹ã®ã‹ã‚’è¦‹ã‚‹ã€‚ INSERT /*+ APPEND_VALUES */ INTO A(COLUMN1) VALUES('hoge'); ç’°å¢ƒ jdk1.7.0_17
doboccho 2014/12/25
Oracle

SQL
ãƒªãƒ³ã‚¯
LISTAGGï¼ˆé›†è¨ˆé–¢æ•°ï¼‰ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL é–¢æ•°ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
å…¨å“¡ã® name ã‚’ä¸¦ã³é †ã‚’æ°—ã«ã›ãšã«é€£çµã™ã‚‹ã€‚ WITHIN GROUP ã¯çœç•¥ã§ããªã„ã®ã§æ„å‘³ã®ãªã„ ã€Œorder by nullã€ ã‚’æŒ‡å®šã—ã¦ã¿ãŸã€‚æ•°å€¤ã‚’æŒ‡å®šã—ã¦ã‚‚ã‚«ãƒ©ãƒ ã®ç¬¬ N ç•ªç›®ã§ã‚½ãƒ¼ãƒˆã¨ã„ã†ã‚ã‘ã§ãªã„ã€‚ Oracle 11g R2 æ™‚ç‚¹ã§ã¯å®Ÿè¡Œè¨ˆç”»ã« SORT GROUP BY ãŒã‚ã‚Šã€æš—é»™çš„ã« expr æ˜‡é †ã«ã‚½ãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€‚ SQL> selectÂ LISTAGG(name) WITHIN GROUP (order byÂ null) concat_name 2 Â Â from listagg_sample; CONCAT_NAME -------------------------------------------------- ã‚ãŠãã“ã°ã‚„ã—ã•ã¨ã†ã™ãšããŸã‹ã¯ã—ã‚„ã¾ã‚‚ã¨ éƒ¨é–€æ¯Žã«åå‰ã‚’ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§é€£çµã™ã‚‹ã€‚åå‰ã®ä¸¦ã³é †ã¯çµ¦æ–™ã®é«˜ã„é † SQL> selectÂ dep
doboccho 2014/08/08
CSV

SQL

DB
ãƒªãƒ³ã‚¯
Write SQL in Java 8 using ResultSet Streams.
SQL in Java 8: ResultSet Streams. With Java 8, writing SQL will change fundamentally, no matter what API you're using. List<Schema> result = new ArrayList<>(); try (Connection c = getConnection()) { String sql = "select schema_name, is_default " + "from information_schema.schemata " + "order by schema_name"; try (PreparedStatement stmt = c.prepareStatement(sql); ResultSet rs = stmt.executeQuery())
doboccho 2014/03/04
SQL

java8
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDB 4.0ã€ãŒãƒªãƒªãƒ¼ã‚¹ã€ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåˆ†æžã‚’é«˜é€ŸåŒ– | OSDN Magazine
ç±³VoltDBã¯1æœˆ29æ—¥ã€ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDB 4.0ã€ã‚’å…¬é–‹ã—ãŸã€‚ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåˆ†æžã®å¼·åŒ–ã€ç¨¼åƒä¸ã®ã‚¯ãƒ©ã‚¹ã‚¿æ‹¡å¼µãªã©ã€å¤šæ•°ã®æ©Ÿèƒ½ãŒåŠ ã‚ã£ã¦ã„ã‚‹ã€‚ VoltDBã¯Javaã¨C++ã§å®Ÿè£…ã•ã‚ŒãŸã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåž‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã€‚Ingresãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã§çŸ¥ã‚‰ã‚Œã‚‹ãƒžã‚µãƒãƒ¥ãƒ¼ã‚»ãƒƒãƒ„å·¥ç§‘å¤§å¦ï¼ˆMITï¼‰ã®Michael Stonebrakeræ°ã‚‰ãŒä¸å¿ƒã«ãªã£ã¦é–‹ç™ºã—ãŸã€‚1ç§’ã§æ•°ç™¾ä¸‡å˜ä½ã®èªã¿è¾¼ã¿/æ›¸ãå‡ºã—ã€ãƒŸãƒªç§’ãƒ¬ãƒ™ãƒ«ã§ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã¨ã„ã£ãŸé«˜é€Ÿãªå‡¦ç†ãŒç‰¹å¾´ã€‚ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ã€ACIDæº–æ‹ ã€SQLã¨JSONã‚µãƒãƒ¼ãƒˆã¨ã„ã£ãŸæ©Ÿèƒ½ã‚’å‚™ãˆã‚‹ã€‚å‹•ä½œç’°å¢ƒã¯Mac OS XãŠã‚ˆã³Linuxã§ã€ä¸€éƒ¨ã®é«˜åº¦æ©Ÿèƒ½ãŒå…¥ã£ã¦ã„ãªã„ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã¯AGPLv3ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ VoltDB 4.0ã¯2013å¹´1æœˆã«å…¬é–‹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0ä»¥æ¥ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒªãƒªãƒ¼ã‚¹ã¨ãªã‚‹ã€‚ã‚¤ãƒ³
doboccho 2014/02/03
SQL

java

voltdb

NoSQL
ãƒªãƒ³ã‚¯
ç´¹ä»‹ï¼šã€æ›¸ç±ã€‘SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çˆ¶ã€ã‚¨ãƒ‰ã‚¬ãƒ¼ãƒ»Fãƒ»ã‚³ãƒƒãƒ‰æ°ãŒè«–æ–‡ã‚’ç™ºè¡¨ã—ãŸã®ã¯1970å¹´ã€‚ç§ãŒç”Ÿã¾ã‚Œã‚‹å‰ã®è©±ã§ã‚ã‚‹ã€‚ãã—ã¦SQLãŒANSIæ¨™æº–ã«ãªã£ãŸã®ãŒ1986å¹´ã€‚RDBMSã‚’ã€ãã—ã¦SQLã‚’ä½¿ã£ãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã¯å¸¸ã«ä¸»æµã§åœ¨ã‚Šç¶šã‘ãŸã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã€‚ãã‚“ãªæ´å²ã®ã‚ã‚‹SQLã§ã‚ã‚‹ãŒã€æœªã ã«å¤šãã®äººã¯SQLã‚’ä½¿ã„ã“ãªã›ã¦å±…ãªã„ã‚ˆã†ã«è¦‹ãˆã‚‹ã€‚ SQLã¯ã¨ã¦ã‚‚å¥¥ãŒæ·±ã„ã€‚ã‚½ãƒ¼ãƒˆã‚„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒä½¿ç”¨å‡ºæ¥ã‚‹ãŠã‹ã’ã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ç„¡è¦–ã—ã¦å˜ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã®å…¥ã‚Œç‰©ã¨ã—ã¦ä½¿ã£ã¦ã‚‚ãã‚Œãªã‚Šã«ä¾¿åˆ©ã ã£ãŸã‚Šã™ã‚‹ã€‚ã ãŒã€ãã‚ŒãŒä»Šç¾åœ¨å¤šãã®æ‚²åŠ‡ã‚’ç”Ÿã‚“ã§ã„ã‚‹åŽŸå› ã§ã‚‚ã‚ã‚‹ã€‚å¤šãã®äººãŒåŒã˜ã‚ˆã†ã«SQLã‚’ç†è§£ã›ãšã€ãã®ãŸã‚å¤šãã®äººãŒåŒã˜æ‚²åŠ‡ã«è¦‹èˆžã‚ã‚Œã‚‹ã€‚ãã†ã€ãã‚ŒãŒã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã‚ã‚‹ï¼ ä»Šå›žç´¹ä»‹ã™ã‚‹SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã€æ´‹æ›¸SQL Antipatternsã®é‚¦è¨³ç‰ˆã ã€‚ç§ã¯å…ƒã€…è‹±èªžç‰ˆã®ãƒ•ã‚¡ãƒ³ã§ã§ã‚ã‚Šã€äººã€…ãŒé™¥ã‚Š
doboccho 2013/01/27
SQL

DB
ãƒªãƒ³ã‚¯
ã€æŠ€è¡“è§£èª¬ã€‘Oracle TimesTenã®ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚’ã²ã‚‚è§£ã
ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆIMDBï¼‰ã¯ã€ç±³Oracleã®ã€ŒOracle TimesTenã€ãªã©ã®ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã®å ´åˆã‚‚ã‚ã‚Œã°ã€ç±³Sybaseã®ã€ŒSybase Adaptive Server Enterpriseï¼ˆASEï¼‰ã€ã®ã‚ˆã†ã«DBMSã®ä¸€éƒ¨ã‚’æ§‹æˆã™ã‚‹å€‹åˆ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å ´åˆã‚‚ã‚ã‚‹ã€‚ IMDBã®ç‹™ã„ã¯ã€ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’æœ€å¤§åŒ–ã—ã€é…å»¶ã‚’æœ€å°åŒ–ã™ã‚‹ãŸã‚ã«ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®ãƒ¡ãƒ¢ãƒªã‚’ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã‚ã‚‹ã€‚ã“ã“ãŒã€ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’åˆ©ç”¨ã™ã‚‹å¾“æ¥åž‹DBMSã¨ç•°ãªã‚‹ã¨ã“ã‚ã ã€‚ãƒ‡ã‚£ã‚¹ã‚¯ã‚’æœ€é©åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ˆã‚Šã‚‚IMDBã®æ–¹ãŒé«˜é€Ÿãªã®ã¯ã€å†…éƒ¨ã®æœ€é©åŒ–ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ãŒå˜ç´”ã§ã€å®Ÿè¡Œã™ã¹ãCPUå‘½ä»¤ã‚‚å°‘ãªã„ã‹ã‚‰ã ã€‚ãƒ¡ãƒ¢ãƒªå†…ã®ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã€é«˜é€Ÿãªå¿œç”ãŒå¯èƒ½ã¨ãªã‚‹ã€‚å–å¼•ã‚·ã‚¹ãƒ†ãƒ ã€é›»æ°—é€šä¿¡ã€é˜²è¡›ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ˆã†ã«å¿œç”æ™‚é–“ãŒæ¥µã‚ã¦é‡è¦ãªæ„å‘³ã‚’æŒã¤ç”¨é€”ã§IMD
doboccho 2012/06/11
SQL

Oracle

TimesTen
ãƒªãƒ³ã‚¯
2Way SQLãƒ‘ãƒ¼ã‚µã¨ã—ã¦ã®Mirage, Doma, Clione-SQLã®æ¯”è¼ƒ - marsã®ãƒ¡ãƒ¢
å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã«å¯¾ã—ã¦ï¼Œã“ã‚“ãªåå¿œãŒã‚ã‚Šã¾ã—ãŸã®ã§ï¼Œã€Œãªã‚‹ã»ã©ï¼ã€ã¨æ€ã„è©¦ã—ã¦ã¿ãŸã‚ˆï¼ˆæœ€è¿‘ï¼Œã“ã‚Œã°ã£ã‹ï½— ã‚ã¨ï¼Œã“ã¡ã‚‰ã‚‚ã€‚â†’ 2 Way SQLãƒ‘ãƒ¼ã‚µã¨ã—ã¦ã®Doma - taediumã®æ—¥è¨˜ å€™è£œã«æŒ™ã’ãŸã®ã¯ï¼ŒSeasarç³»2Way SQLã¨ã—ã¦Mirageã¨Domaï¼Œã‚ã¨ç‹¬è‡ª2Way SQLã®Clione-SQLã®ï¼“ã¤ã€‚ãã‚Œãžã‚Œï¼Œã‚‚ã¨ã‚‚ã¨SQLãƒ‘ãƒ¼ã‚µå˜ç‹¬ã§ä½¿ã‚ã‚Œã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¦ã„ãªã„ã®ã§ï¼Œãã‚Œãªã‚Šã«ç„¡ç†ã‚’ã—ã¦è©¦ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ è©¦ã—ãŸã‚³ãƒ¼ãƒ‰ä¸€å¼ã¯ã“ã¡ã‚‰ã«ãŠã„ã¦ãŠãã¾ã™ã€‚ â†’ GitHub - masanobuimai/2way-sql-parser æœ€ä½Žé™å¿…è¦ã¨ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒª Mirageä»¥å¤–ã¯è‡ªåˆ†è‡ªèº«ã®Jarãƒ•ã‚¡ã‚¤ãƒ«ï¼‘ã¤ã ã‘ã§OKã€‚ã‚µã‚¤ã‚ºã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ Mirage mirage-1.1.4.jar(185k), ognl-2.7.3.jar(234k), javas
doboccho 2012/04/20
SQL

Java
ãƒªãƒ³ã‚¯
Oracleã§æµã‚ŒãŸSQLã‚’å–å¾—ã™ã‚‹ã«ã¯ - ãƒãƒƒã‚¯ãƒ‘ãƒƒã‚«ãƒ¼ãƒ—ãƒã‚°ãƒ©ãƒžã®å‚™å¿˜éŒ²
Oracleã§ã¯æµã‚ŒãŸSQLã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã§å¾Œã‹ã‚‰è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ æ–¹æ³•ã¯V$SQLã«ä»¥ä¸‹ã®ã‚ˆã†ãªselectã‚’ã‹ã‘ã‚‹ã€‚ SELECT * FROM V$SQL WHERE PARSING_SCHEMA_NAME = 'HOGE' AND ROWNUM < 100 AND SQL_TEXT LIKE '%SELECT MOGA%' ä½¿ã£ãŸSQLã®ä¸€éƒ¨ã§ã‚‚ã‚ã‹ã‚Œã°ã“ã‚Œã§å¼•ã£ã‹ã‹ã‚‹ã ã‚ã†ã€‚ ã—ã‹ã—SQL_TEXTã¯1000æ–‡å—ã¾ã§ã—ã‹ä¿å˜ã•ã‚Œã¦ã„ãªã„ã®ã§ã€ ãã‚Œä»¥ä¸Šã«ãªã‚‹å ´åˆã¯ä¸Šè¨˜SQLã§SQL_IDãŒã‚ã‹ã‚‹ã®ã§ãã‚Œã‚’å…ƒã«ä»¥ä¸‹ã®ã‚ˆã†ãªSQLã‚’æŠ•ã’ã‚Œã°è‰¯ã„ã€‚ SELECT sql_text FROM v$sql text WHERE sql_id = '&sql_id' ORDER BY piece; ã“ã‚Œã§å…¨æ–‡ãŒè¦‹ãˆã‚‹ã¯ãšã ã€‚ å‚è€ƒãƒªãƒ³ã‚¯ http://odakeiji.blog33.fc2
doboccho 2011/01/13
SQL

Oracle
ãƒªãƒ³ã‚¯
1