No. of vowels and consonants in a given string in PL/SQL
Prerequisite – PL/SQL introduction
In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations.
Given a string and the task is to find the number of vowels and consonants present in the string.
Input: str = 'Ramesh'
Output: Vowels = 2, Consonants = 4
Input: str = 'Ramesh is a Geek'
Output: Vowels = 6, Consonants = 7
Approach is to consider a character one by one and maintain a separate count for both vowels and consonants.
Below is the required implementation:
v VARCHAR2(400) :=
'Ramesh is a Geek'
noofvowels NUMBER := 0;
noofconsonants NUMBER := 0;
c := Substr(v, i, 1);
noofvowels := noofvowels + 1;
noofconsonants := noofconsonants + 1;
'No. of Vowels: '
'No. of Consonants: '
No. of Vowels: 6
No. of Consonants: 7
Unlock the Power of Placement Preparation!
Feeling lost in OS, DBMS, CN, SQL, and DSA chaos? Our Complete Interview Preparation
Course is the ultimate guide to conquer placements. Trusted by over 100,000+ geeks, this course is your roadmap to interview triumph.
Ready to dive in? Explore our Free Demo Content and join our Complete Interview Preparation