using regexp_instr to find the number of occurences of a delimeter
Posted on 2006-07-06
REGEXP_INSTR('500 Oracle Parkway, Redwood Shores, CA', '[^,]+', 1, 2) "REGEXP_INSTR"
the above gets the position of the second comma
How would I modify the above to find the number of occurences of a comma. Not sure if this is the way to go. Any sugestions appreciated.
Thanks in advance.
REGEXP_INSTR(<source_string>, <pattern>, <start_position>, <occurrence>, <return_option>, <match_parameter>)