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

Показать описание

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

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

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

Рекомендации по теме

Комментарии

Nice explanation!!. I have solved it with using only translate and regexp_count function.
with t1 as (select first_name
, regexp_count(translate(lower(first_name),'a','1'),'1') a_cnt
, regexp_count(translate(lower(first_name),'e','1'),'1') e_cnt
, regexp_count(translate(lower(first_name),'i','1'),'1') i_cnt
, regexp_count(translate(lower(first_name),'o','1'),'1') o_cnt
, regexp_count(translate(lower(first_name),'u','1'),'1') u_cnt
from employees),
t2 as (select t1.*,
a_cnt+e_cnt+i_cnt+o_cnt+u_cnt All_vowel_tot
from t1)
select *
from t2

LearnA-smart

Thanks a lot for your all videos.
It gives me confidence and even gitz job recently.

Thanks alot

nandiniagarwal

Thank u Siva for teaching in easy way ... If possible please make videos on security measures we need to follow while writing procedures, packages and how to avoid sql injection, second order sql injection, parameter tampering, etc

ujjwalkarn

What is lateral join?
Please make a lecture on it

karnarajmahajan

Hi bro can you make videos on commit rollback?

rajathjain

Hi gi.last time I have asked one request but I have not get yet pls.. that is my database is accept Hindi, Marathi, kanada, urudu, Malayalam but Tamil data only it's not accept..pls help me..

SelvaKumar-hgho

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

Oracle SQL Practical question | Oracle SQL to print the all possible combination of numbers

Oracle SQL Practical question SQL to Find number of saturday and sunday

sql Tricky developer interview questions for 2+ years experience Operators

Oracle SQL Practical question with answer Write a SQL to print Cricket Dashboard

Oracle SQL Practical question | SQL to compute year end credit card balance

Oracle SQL Practical question with answer extract names from mail id using SQL function

Oracle SQL Practical question | Oracle SQL to compute group number for repeating number

Oracle SQL Practical question Write a sql to replace the comma separated value

Oracle SQL Practical question | SQL to find the set of rows in hierarchical relational data

Oracle SQL Practical question with answer calculate the group salary

SQL Query to Calculate The Difference Between Two Dates? SQL Interview Questions And Answers #SQL

Oracle SQL Practical question | Oracle SQL to Compute values based on previous rows

Oracle SQL Practical question with answer | SQL to convert list of numbers into table format

Oracle SQL Practical question | SQL to convert comma separated string to rows and vice versa

Oracle sql practice exercise with solution | SQL query to print string in row of characters |PYRAMID

Oracle SQL Practical question | SQL to summarize data one row for continuous play of album

Oracle SQL Practical question with answer extract names from mail id using SQL function

Coalesce function in SQL with best examples #sql #shorts #coding #sqlqueries #sqlserver

Oracle SQL Practical question | SQL to convert data representation in different format

Oracle SQL Practical question | Oracle SQL to Find missing number in given range of values

Oracle SQL Practical question with answer Write a SQL to print Cricket Dashboard

🤔 Find Nth Highest Salary sql #sql #sqlinterviewquestionsandanswers

Oracle SQL Practical question with answer | Compute the start and end value of group in given seq

5 Best SQL Websites to Practice n Learn Interview Questions for FREE