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

SNOWFLAKE Interview Questions 2025

  1️ ⃣ Choosing the Perfect Size of Virtual Warehouse To select the right size (X-Small to 6X-Large), consider: Data Volume ...