StratoSphere Stream
SELECT REGEXP_SUBSTR( STR, '[()][(A-Za-z가-힣)]+[()]') FROM REG_TEST select REGEXP_SUBSTR(STR, '[^ ]+', 1, LEVEL), COUNT(REGEXP_SUBSTR(STR, '[^ ]+', 1, LEVEL)) A from REG_TEST CONNECT BY LEVEL