Oracle Practice Sheet

Oracle Practical Sheet -1

Oracle Practice

a

Oracle Practical Sheet -1

1. Write a code to print “Hello World in PLSQL block”.

2. Write a program to enter two numbers and find their sum in PLSQL block .

3.Write a program to enter two numbers and perform all arithmetic operations in PLSQL block.

4. Write a program to enter length and breadth of a rectangle and find its perimeter in PLSQL block.

5. Write a program to enter length and breadth of a rectangle and find its area in PLSQL block.

6.Write a program to enter radius of a circle and find its diameter, circumference and area in PLSQL block.

7.Write a program to enter length in centimeter and convert it into meter and kilometer in PLSQL block.

8.Write a program to enter temperature in Celsius and convert it into Fahrenheit in PLSQL block.

9.Write a program to enter temperature in Fahrenheit and convert to Celsius in PLSQL block.

10. Write a program to convert days into years, weeks and days in PLSQL block.

11. Write a program to find power of any number x ^ y in PLSQL block.

12. Write a program to enter any number and calculate its square root in PLSQL block.

13. Write a program to enter two angles of a triangle and find the third angle in PLSQL block.

14. Write a program to enter base and height of a triangle and find its area in PLSQL block.

15. Write a program to calculate area of an equilateral triangle in PLSQL block.

16. Write a program to enter marks of five subjects and calculate total, average and percentage in PLSQL block.

17. Write a program to enter P, T, R and calculate Simple Interest in PLSQL block.

sign up!

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

© Copyright CODEMANIAC STUDIO ™