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

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...