Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

No. of vowels and consonants in a given string in PL/SQL

  • Last Updated : 05 Jul, 2018

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.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

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:

    -- Here variable V is varchar datatype  
    -- and  flag variable is number datatype   
    -- variable c is char datatype .  
    v              VARCHAR2(400) := 'Ramesh is a Geek'
    noofvowels     NUMBER := 0; 
    noofconsonants NUMBER := 0; 
    C              CHAR
    FOR i IN 1..Length(v) LOOP 
        c := Substr(v, i, 1); 
        -- Check if the current character is vowel 
        IF c IN ( 'A', 'E', 'I', 'O', 'U'
            OR c IN ( 'a', 'e', 'i', 'o', 'u' ) THEN 
          noofvowels := noofvowels + 1; 
        -- Else current character is a consonant except space 
          IF c NOT IN ( ' ' ) THEN 
            noofconsonants := noofconsonants + 1; 
          END IF; 
        END IF; 
    END LOOP; 
    dbms_output.Put_line('No. of Vowels: ' 
                         || noofvowels); 
    dbms_output.Put_line('No. of Consonants: ' 
                         || noofconsonants); 
-- Program End  

Output :

No. of Vowels: 6
No. of Consonants: 7

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!