Oracle SQL Practical question | SQL to count number of occurrences of a vowels in a string

Oracle SQL Practical question | SQL to count number of occurrences of a vowels in a string
---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

---------------------------------------------------------------------------------------------------------------------------

[gautamtrivedi]

Sir always find helpful watching your video.
Sir requesting you to please make Full video on all regexp .This will also be helpful.

[suraj]

Really helpful for interview aspect. Thanx shiva..

[ragunarayananr]

Thalaiva sema ya explain panrenga... Unix related videos um post pannuga thalaiva rmba useful ah irukum... Thank u

[maheshbabuthummala]

I felt as mind-blowing answer. Video is very helpful 😊. Thanks bro

[deepakjagdale]

Nice explaination sir .. Thank you for video

[Dpanneerselvam]

Translate, replace and length function helps me get the same result.

[suraj]

1) kindly make video on procedure with IN, OUT, INOUT parameters with examples??
2) Can we create procedure inside procedure???
3) Make detail video on types of materialized view and work flow ??

[manoharreddy]

SIR, HOW TO COUNT NUMBER OF CHARCTERS IN A STRING LIKE NUMBER OF A's PRESENT IN AMAR

[mohan]

Sir,
You can also do a check in mixed cases as well:
select regexp_count('SUBASHIS Oracle', '[aeiouAEIOU]') from dual;
Answer : 6

[venkatv]

Please make videos of predefined packages like dbms_aq

[Pmreedy]

can use a listAgg as wherein pivot class?

[Lakimohanty]

Can we ans this question using length and replace function

[mohan]

Sir,
You need only one command in Regular expression :

select regexp_count('SUBASHIS ORACLE', 'A|O|E|I|U') from dual;
Answer: 6

Thanks

[amrutaborse]

select * from (
select str1, str,count(*) cnt from
(select substr(upper('Subhashis Oracle'), level, 1) str, upper('Subhashis Oracle') str1
from dual connect by level <= length('Subhashis Oracle'))
where str in ('A', 'E', 'I', 'O', 'U')
group by str, str1)
pivot(max(cnt) for str in ('A', 'E', 'I', 'O', 'U'));

[prakashchakravarthyg]

--WITHOUT using REGULAR EXPRESSION
WITH ds1 AS
--To display individual characters of ename based on LENGTH(ename)
(SELECT eno, ename,
SUBSTR(UPPER(ename), LVL, 1) c_char
FROM emp_temp, LATERAL(SELECT LEVEL lvl
FROM dual
CONNECT BY LEVEL <= LENGTH(ename)))
--Select only rows with c_char = {A, E, I, O, U} and COUNT using DECODE
SELECT eno, ename,
COUNT(DECODE(c_char, 'A', 1)) A_count,
COUNT(DECODE(c_char, 'E', 1)) E_count,
COUNT(DECODE(c_char, 'I', 1)) I_count,
COUNT(DECODE(c_char, 'O', 1)) O_count,
COUNT(DECODE(c_char, 'U', 1)) U_count
FROM ds1
WHERE c_char IN ('A', 'E', 'I', 'O', 'U')
GROUP BY eno, ename;