In PLSQL there are functions like INSTR, SUBSTR, REPLACE, but
to Count number of occurrences of a character in the string there is no standard function.
Here is a simple way, In the example below I am trying to find out the number of
occurrence of '|' in the string
select length('san|tom|elp|ert|') -
length(replace('san|tom|elp|ert|','|')) count from dual;
to Count number of occurrences of a character in the string there is no standard function.
Here is a simple way, In the example below I am trying to find out the number of
occurrence of '|' in the string
select length('san|tom|elp|ert|') -
length(replace('san|tom|elp|ert|','|')) count from dual;
2 comments:
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Post a Comment