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;
3 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.
25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students
Please Check https://www.oracleappstechnical.com for details
Post a Comment