oracle 7

Cannot create PoolableConnectionFactory (๋กœ์ผ€์ผ์„ ์ธ์‹ํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค.)

ํ˜„์ƒ : OS X El Capitan -> mac OS Sierra ๋กœ ์—…๊ทธ๋ ˆ์ด๋“œ ํ›„ ์•„๋ž˜์™€ ๊ฐ™์€ ํ˜„์ƒ์ด ๋ฐœ์ƒ java.sql.SQLException: Cannot create PoolableConnectionFactory (๋กœ์ผ€์ผ์„ ์ธ์‹ํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค.) 1 > POST http://localhost:8081/restapi/V1/auth/token/publish 1 > accept: */* 1 > accept-encoding: gzip, deflate 1 > accept-language: ko-KR 1 > connection: keep-alive 1 > content-length: 108 1 > content-type: application/x-www-form-urlencoded 1 > host: lo..

ORACLE ์‹œ๊ฐ„์ฐจ ํ™˜์‚ฐ (์ดˆ->์‹œ๊ฐ„ / ์‹œ๊ฐ„->์ดˆ)

ORACLE SQL ์‹œ๊ฐ„์ฐจ๋ฅผ ์ดˆ๋กœ ํ™˜์‚ฐSELECT systimestamp(3) - tm AS interval , EXTRACT(DAY FROM systimestamp(3) - tm) *24*60*60 + EXTRACT(HOUR FROM systimestamp(3) - tm) *60*60 + EXTRACT(MINUTE FROM systimestamp(3) - tm) *60 + EXTRACT(SECOND FROM systimestamp(3) - tm) AS second FROM (SELECT TO_TIMESTAMP('14/01/13 17:40:33.751', 'yy/mm/dd hh24:mi:ss.ff3') tm FROM dual) ์ดˆ๋ฅผ ์‹œ๊ฐ„์œผ๋กœ ํ™˜์‚ฐSELECT (TRUNC(4215/(60*60))) ||'์‹œ..

์˜ค๋ผํด (ํ…Œ์ด๋ธ”, ์ปฌ๋Ÿผ) ์ •๋ณด๋ณด๊ธฐ, ์ƒ์„ฑ, ์ˆ˜์ •, ๋ณ€๊ฒฝ, ์‚ญ์ œ

์ถœ์ฒ˜ : http://todduf.blogspot.kr/2012/02/blog-post.html ์˜ค๋ผํด (ํ…Œ์ด๋ธ”, ์ปฌ๋Ÿผ) ์ •๋ณด๋ณด๊ธฐ, ์ƒ์„ฑ, ์ˆ˜์ •, ๋ณ€๊ฒฝ, ์‚ญ์ œview plainprint?----------------------------------------------------------------------------------------------------------------------- -- ๋ชจ๋“  ํ…Œ์ด๋ธ” ์ •๋ณด ๋ณด๊ธฐ SELECT * FROM user_tables; -- ๋ชจ๋“  ํ…Œ์ด๋ธ” ์ฝ”๋ฉ˜ํŠธ ์ •๋ณด ๋ณด๊ธฐ SELECT * FROM user_tab_comments; -- ๋ชจ๋“  ์ปฌ๋Ÿผ ์ •๋ณด ๋ณด๊ธฐ SELECT * FROM user_tab_cols; -- ๋ชจ๋“  ์ปฌ๋Ÿผ ์ฝ”๋ฉ˜ํŠธ ์ •๋ณด ๋ณด๊ธฐ SELECT * FROM u..

DDLGenerator

โ–  MySQL์—์„œ DDL๋ฝ‘๊ธฐ import java.io.File; import java.io.FileWriter; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * MySQL Object(Table, Vie..

์ปฌ๋Ÿผ๋ช…์œผ๋กœ ํ…Œ์ด๋ธ” ์ฐพ๊ธฐ ์˜ˆ์ œ

์ง‘์ฃผ์†Œ ๊ด€๋ จ๋œ ์˜ˆ์ƒ๋˜๋Š” ์ปฌ๋Ÿผ๋ช…์— ๋Œ€ํ•œ ํ…Œ์ด๋ธ” ๋ฝ‘๊ธฐ SELECT B.TABLE_NAME, B.COLUMN_NAME, COMMENTS FROM ALL_COL_COMMENTS A, ALL_TAB_COLUMNS B WHERE A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND (UPPER(B.COLUMN_NAME) LIKE '%ZIP%' OR UPPER(B.COLUMN_NAME) LIKE '%DNG%' OR UPPER(B.COLUMN_NAME) LIKE '%ADDR%' OR COMMENTS LIKE '%์ฃผ์†Œ%') AND (UPPER(B.COLUMN_NAME) NOT LIKE '%IP%' OR UPPER(B.COLUMN_NAME) NOT LIKE ..

Connect BY

๊ณ„์ธตํ˜• ๊ฒŒ์‹œํŒ ๊ฐ™์ด ํŠธ๋ฆฌ๊ตฌ์กฐ๋กœ ๋˜์–ด ์žˆ๋Š” DB๋ฅผ ์‚ญ์ œ, ์ •๋ ฌ, ๊ธฐํƒ€ ๋“ฑ๋“ฑ ํŠธ๋ฆฌ๊ตฌ์กฐ์—์„œ ํŽธํ•˜๊ฒŒ ์‚ฌ์šฉ ํ˜•ํƒœ ๊ธ€๋ฒˆํ˜ธ ๊ทธ๋ฃน ๋’™์“ฐ ์‹œํ€€์Šค ๋ถ€๋ชจ๊ธ€ 1 1 1 0 1 0 โ”” 3 3 1 1 2 1 โ”‚ โ”” 5 5 1 2 3 3 โ”‚ โ”” 6 6 1 3 4 5 โ”” 2 2 1 1 5 1 โ”” 4 4 1 2 6 2 ์‚ฌ์šฉ๋ฒ• ) 3๋ฒˆ๊ธ€์„ ์ง€์šฐ๋ คํ•œ๋‹ค๋ฉด ๊ทธ ํ•˜์œ„ ๋‹ต๋ณ€์ธ 5,6๋ฒˆ ๊ฒŒ์‹œ๋ฌผ๋„ ์ง€์›Œ์ ธ์•ผ ํ•œ๋‹ค. DELETE FROM S_BOARD WHERE ๊ธ€๋ฒˆํ˜ธ IN ( SELECT * FROM S_BOARD START WITH ๊ธ€๋ฒˆํ˜ธ = 3 //์‹œ์ž‘ํ•˜๋Š” ๋ถ€๋ถ„ CONNECT BY PRIOR ๊ธ€๋ฒˆํ˜ธ = ๋ถ€๋ชจ๊ธ€ //๊ฒ€์ƒ‰ ๋Œ€์ƒ์„ ํŠธ๋ฆฌํ˜•ํƒœ๋กœ ๊ฒ€์ƒ‰ ORDER BY ๊ทธ๋ฃน DESC, ์ˆœ์„œ ) * prior์˜ ์œ„์น˜ - connect by prior ์ž์‹์ปฌ๋Ÿผ ..

RANK()

์˜ค๋ผํด์—์„œ๋Š” RANK Function์„ ์‚ฌ์šฉํ•ด์„œ ์ˆœ์œ„๋ฅผ ๊ฐ„ํŽธํ•˜๊ฒŒ ๋ถ€์—ฌํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. RANK Function๋Š” oracle 8i(8.1.6) ๋ถ€ํ„ฐ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. 8.1.6 ์ด์ „ ๋ฒ„์ „์—์„œ๋Š” ์‚ฌ์šฉ ํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค. ORA-923 error ๊ฐ€ ๋ฐœ์ƒ ํ•ฉ๋‹ˆ๋‹ค. plsql ๋‚ด์—์„œ๋Š” oracle 9i ๋ถ€ํ„ฐ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. 8.1.6์—์„œ๋Š” ORA-900 error๊ฐ€ ๋ฐœ์ƒ ํ•ฉ๋‹ˆ๋‹ค. -- scott์œ ์ €๋กœ ์ ‘์†์„ ํ•ฉ๋‹ˆ๋‹ค. SQLPLUS scott/tiger ---------------------------------------------------------------------------------------------------------------- ---------------------------------------..