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
Post a Comment