PLSQL: ITERATIVE CONTROL STATEMENT: SIMPLE LOOP, WHILE LOOP, FOR LOOP

Write a PL/SQL block to print numbers from 1 to 5 using SIMPLE LOOP.

(SIMPLE LOOP)

Write a PL/SQL block to display numbers from 10 to 1 in reverse order.

(SIMPLE LOOP)

Write a PL/SQL block to calculate the sum of numbers from 1 to 10.

(SIMPLE LOOP)

Write a PL/SQL block to print multiplication table of a number using SIMPLE LOOP.

(SIMPLE LOOP)

Write a PL/SQL block to print even numbers between 1 and 20.

(SIMPLE LOOP)

Write a PL/SQL block that exits the loop when a number becomes greater than 50.

(SIMPLE LOOP + EXIT)

Write a PL/SQL block to print numbers from 1 to 10 using WHILE LOOP.

(WHILE LOOP)

Write a PL/SQL block to calculate factorial of a number using WHILE LOOP.

(WHILE LOOP)

Write a PL/SQL block to display sum of digits of a number using WHILE LOOP.

(WHILE LOOP)

Write a PL/SQL block to reverse a number using WHILE LOOP.

(WHILE LOOP)

Write a PL/SQL block to check whether a number is palindrome using WHILE LOOP.

(WHILE LOOP)

Write a PL/SQL block to print Fibonacci series up to N terms using WHILE LOOP.

(WHILE LOOP)

Write a PL/SQL block to print numbers from 1 to 10 using FOR LOOP.

(FOR LOOP)

Write a PL/SQL block to print numbers in reverse order using FOR LOOP.

(FOR LOOP)

Write a PL/SQL block to calculate sum of first 10 natural numbers using FOR LOOP.

(FOR LOOP)

Write a PL/SQL block to display multiplication table of 5 using FOR LOOP.

(FOR LOOP)

Write a PL/SQL block to print squares of numbers from 1 to 10.

(FOR LOOP)

Write a PL/SQL block to display all odd numbers between 1 and 50.

(FOR LOOP)

Write a PL/SQL block to print a pattern using nested loops:

*

**

***

****

(Nested LOOP)

Write a PL/SQL block to print multiplication tables from 1 to 5.

(Nested LOOP)

Write a PL/SQL block to display a number pattern:

1

12

123

1234

(Nested LOOP)

Write a PL/SQL block to print numbers from 1 to 20 but skip multiples of 4.

(LOOP + CONTINUE)

Write a PL/SQL block to stop printing numbers once the sum exceeds 100.

(LOOP + EXIT)

Write a PL/SQL block to print numbers and exit when number divisible by 7 is found.

(LOOP + EXIT)

Write a PL/SQL block to loop through employee IDs from EMP table and display them.

(FOR LOOP + Table Data)

Write a PL/SQL block to increase salary of employees by 10% using loop.

(LOOP + UPDATE)

Write a PL/SQL block to display employees whose salary is greater than 3000 using loop.

(LOOP + CONDITION)

Write a PL/SQL block to count total number of employees using loop.

(LOOP + COUNT)

Write a PL/SQL block using all three loops (SIMPLE, WHILE, FOR) in one program.

(Combined Loops)

Write a PL/SQL block to generate prime numbers between 1 and 50.

(LOOP + LOGIC)

Write a PL/SQL block to simulate ATM withdrawal attempts (3 attempts using loop).

(LOOP + Practical)

Write a PL/SQL block to calculate sum of even and odd numbers separately using loop.

(LOOP + CONDITION)