Scribd
Upload
280 views2 pages

Essential PL/SQL Programming Tasks

The document provides a practical list of 31 PL/SQL programming problems to solve that cover a variety of programming concepts like variables, loops, conditions, functions, patterns, strings and more. Some examples include programs to arrange numbers, check if a number is even or odd, convert temperatures, use loops with continue/exit statements, find prime numbers, swap values, check for palindromes and more. The list aims to help learn and practice a wide range of PL/SQL programming techniques.

Uploaded by

NEHA DEWANGAN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
280 views2 pages

Essential PL/SQL Programming Tasks

The document provides a practical list of 31 PL/SQL programming problems to solve that cover a variety of programming concepts like variables, loops, conditions, functions, patterns, strings and more. Some examples include programs to arrange numbers, check if a number is even or odd, convert temperatures, use loops with continue/exit statements, find prime numbers, swap values, check for palindromes and more. The list aims to help learn and practice a wide range of PL/SQL programming techniques.

Uploaded by

NEHA DEWANGAN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Practical List of PL/SQL

1. Write a PL/SQL program to arrange the number of two variable in such a way that the
small number will store in num_small variable and large number will store in num_large
variable.
2. Write a PL/SQL procedure to calculate the incentive on a target achieved and display the
message either the record updated or not.
3. Write a PL/SQL program to check whether a number is even or odd.
4. Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or
SUNDAY.
5. Write a PL/SQL program to display the description against a grade.
6. Write a PL/SQL program to display the description against a grade using CASE statement.
7. Write a PL/SQL program to display the description against a grade using CASE statement
with EXCEPTION.
8. Write a PL/SQL program to check whether a given number is positive, negative or zero.
9. Write a PL/SQL program to check whether a given character is letter or digit.
10. Write a PL/SQL program to convert a temperature in scale Fahrenheit to Celsius and vice
versa.
11. Write a program in PL/SQL to print the value of a variable inside and outside a loop
using LOOP EXIT statement.
12. Write a program in PL/SQL to show the uses of nested loop.
13. Write a program in PL/SQL using nested loop with EXIT WHEN statement.
14. Write a program in PL/SQL using loop with CONTINUE statement.
15. Write a program in PL/SQL to print 1st n numbers.
16. Write a program in PL/SQL to print 1st n numbers with a difference of 3 and starting
from 1.
17. Write a program in PL/SQL to print the prime numbers between 1 to 50.
18. Write a program in PL/SQL to insert records from one table to another.
19.Write a program in PL/SQL to create an implicit cursor with for loop.
20. Write a program in PL/SQL to create an explicit cursor with for loop.
21. Write a program in PL/SQL Program to Find Factorial of a Number
22. Write a program in PL/SQL Program to Print Table of a Number
23. Write a program in PL/SQL Program for Reverse of a Number
24. Write a program in PL/SQL Program for Fibonacci Series
25. Write a program in. PL/SQL Program to Check Number is Odd or Even
26. Write a program in PL/SQL Program to Reverse a String
27. Write a program in Pl/SQL Program for Palindrome Number
28. Write a program in PL/SQL Program to Swap two Numbers
29. Write a program in PL/SQL Program for Armstrong Number
30. Write a program in PL/SQL Program to Find Greatest of Three Numbers
31. Write a program in PL/SQL Program to Print Patterns

* *****
** ****
*** ***
**** **
***** *
* *********
*** *******
***** *****
******* ***
********* *
***** *
**** **
*** ***
** * ***
* ** ***

You might also like