PL/SQL Control Statement Exercises: Print 1st n numbers with a difference of 3 and starting from 1
PL/SQL Control Statement: Exercise-24 with Solution
Write a program in PL/SQL to print 1st n numbers with a difference of 3 and starting from 1.
Sample Solution:
PL/SQL Code:
DECLARE
n number:= &first_n_number;
i number:=1;
m number:=1;
BEGIN
DBMS_OUTPUT.PUT_LINE ('The first '||n||' numbers are: ');
DBMS_OUTPUT.PUT (i||' ');
for i in 1..n-1 loop
m:=m+3;
dbms_output.put(m||' ');
END LOOP;
dbms_output.new_line;
END;
/
Flowchart:

Sample Output:
Enter value for first_n_number: 10 old 2: n number:= &first_n_number; new 2: n number:= 10; The first 10 numbers are: 1 4 7 10 13 16 19 22 25 28 PL/SQL procedure successfully completed.
Improve this sample solution and post your code through Disqus
Previous: Write a program in PL/SQL to print 1st n numbers.
Next: Write a program in PL/SQL to show the value of a same variable declared as local and global.
What is the difficulty level of this exercise?
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- JavaScript functions Exercises
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook