dbms:oracle:devel:regexp:regexp_substr

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- dbms:oracle:devel:regexp:regexp_substr [2018/05/09 02:40]
starlits [페이지정보 찾기]
+++ dbms:oracle:devel:regexp:regexp_substr [2018/05/09 02:41]
starlits [주소문자열 자르기]
@@ 줄 96: / 줄 96: @@
 SELECT
      ADDRESS
-    ,REGEXP_SUBSTR(ADDRESS,\'[^ ]+\') AS SIDO
+    ,REGEXP_SUBSTR(ADDRESS,'[^ ]+') AS SIDO
-    ,REPLACE(REGEXP_SUBSTR(ADDRESS,\' +[^ ]+\'),\' \',\'\') as GUGUN
+    ,REPLACE(REGEXP_SUBSTR(ADDRESS,' +[^ ]+'),' ','') as GUGUN
-    ,REPLACE(ADDRESS,REGEXP_SUBSTR(ADDRESS,\'[^ ]+\')||REGEXP_SUBSTR(ADDRESS,\' +[^ ]+\')||\' \',\'\') AS etc
+    ,REPLACE(ADDRESS,REGEXP_SUBSTR(ADDRESS,'[^ ]+')||REGEXP_SUBSTR(ADDRESS,' +[^ ]+')||' ','') AS etc
-    ,REGEXP_SUBSTR(ADDRESS,\'[^ ]+(.)$\')
+    ,REGEXP_SUBSTR(ADDRESS,'[^ ]+(.)$')
 FROM DV_ADDRESS_TEMP ;
 </code>

dbms/oracle/devel/regexp/regexp_substr.txt · 마지막으로 수정됨: 2019/03/05 00:40 저자 starlits