REGEXP_REPLACE

View All Public Scripts Login to Run Script

Statement 1

SELECT LENGTH(REGEXP_REPLACE('*********', '*', 'X', 3, 1))  FROM DUAL


LENGTH(REGEXP_REPLACE('*********','*','X',3,1))
10

LENGTH(REGEXP_REPLACE('********','','X',3,1))
10

Statement 2

SELECT LENGTH(REGEXP_REPLACE('---------', '-', 'X', 3, 1))  FROM DUAL


LENGTH(REGEXP_REPLACE('---------','-','X',3,1))
9

LENGTH(REGEXP_REPLACE('---------','-','X',3,1))
9

Additional Information