Friday, September 19, 2014

How to Count of Individual Characters in a String Lets see..:)

select ind, count(ind) from (select substr(given_string,rownum,1) ind from(select 'TESTMAN' given_string from all_objects) where rownum<=length(given_string))group by ind



1 comment:

  1. Great stuff provided by the Admin here… look into this for Obiee online training

    ReplyDelete

ADF functions

 toString(JT_DEAL_PLAN_EFF_DT, 'MM/dd/yyyy HH:mm:ss','es-ES')