문서의 이전 판입니다!
SELECT STUDYUNITCODE, REGEXP_SUBSTR(REGEXP_REPLACE(STUDYUNITCODE,\'^0\',\'\'),\'[[:digit:]]{1,2}\') TAPE, REGEXP_SUBSTR(STUDYUNITCODE,\'[[:alpha:]]{1}\') SIDE FROM TB_STUDYUNIT ORDER BY KWON,STUDYUNITCODE
STUDYUNITCODE TAPE SIDE 01A 1 A 10B 10 B 12A 12 A 02B 2 B 23A 23 A 30B 30 B
SELECT SOURCE, REPLACE(REGEXP_SUBSTR(SOURCE,\'p[[:digit:]]{1,3}\'),\'p\',\'\') PAGE FROM QUESTION WHERE ROWNUM < 10;
SOURCE PAGE b1: p24 24 b1: p19, 24, 32, 46 19 b3: p5 5 b3: p29 29 b3: p10-11 10 b2: p22 22 b1: p20 b2: p15 b4: p40 20 b2: p8-9, 30 8 b3: p16-17 16
SELECT ADDRESS ,REGEXP_SUBSTR(ADDRESS,\'[^ ]+\') AS SIDO ,REPLACE(REGEXP_SUBSTR(ADDRESS,\' +[^ ]+\'),\' \',\'\') as GUGUN ,REPLACE(ADDRESS,REGEXP_SUBSTR(ADDRESS,\'[^ ]+\')||REGEXP_SUBSTR(ADDRESS,\' +[^ ]+\')||\' \',\'\') AS etc ,REGEXP_SUBSTR(ADDRESS,\'[^ ]+(.)$\') FROM DV_ADDRESS_TEMP ;
address | sido | gugun | remain | etc |
---|---|---|---|---|
충남 청양군 청양읍 읍내리 175-21 | 충남 | 청양군 | 청양읍 읍내리 175-21 | 175-21 |
충남 청양군 읍내리 209-3 | 충남 | 청양군 | 읍내리 209-3 | 209-3 |
충남 태안군 태안읍 동문리 529-2 | 충남 | 태안군 | 태안읍 동문리 529-2 | 529-2 |
충남 태안군 태안읍 동문리 879-3 | 충남 | 태안군 | 태안읍 동문리 879-3 | 879-3 |