oracle - counting rows returned by regexp_like -


i need count number of rows returned regexp_like() in oracle. how do that? have tried following query in function:

return count(regexp_like(sin, '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$')); 

use regexp_count(https://docs.oracle.com/cd/b28359_01/server.111/b28286/functions135.htm) instead of regexp_like


Comments