CASE STATEMENT IN PLSQL block.

Q.1 Write a PL/SQL program to print day of week name using switch case.
Q.2 Write a PL/SQL program print total number of days in a month using switch case.
Q.3 Write a PL/SQL program to check whether an alphabet is vowel or consonant using switch case.
Q.4 Write a PL/SQL program to find maximum between two numbers using switch case.
Q.5 Write a PL/SQL program to check whether a number is even or odd using switch case.
Q.6 Write a PL/SQL program to check whether a number is positive, negative or zero using switch case.
Q.7 Write a PL/SQL program to find roots of a quadratic equation using switch case.
Q.8 Write a PL/SQL program to create Simple Calculator using switch case.

END 

 

 

 

sign up!

We’ll send you the hottest deals straight to your inbox so you’re always in on the best-kept software secrets.