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
Friday, September 19, 2014
Subscribe to:
Posts (Atom)
-
UNIX shell script Interview Questions How to calculate number of passed arguments ? $# How to get script name inside a script ? $0...
-
Performance improvement Tips using Hint in OBIEE 11g RPD or Other ways.. We can improve the performance of reports by doing tuning using ... -
OBIEE12c Creating Analyses and Dashboards Oracle BI is a comprehensive collection of enterprise business intelligence functionality t...
