PL/SQL is one of three key programming languages which is only available with the Oracle Database. PL/SQL is an relational database.
Copy the below PL/SQL program and execute it. In this program, we are going to share how to reverse a number in PL/SQL with the output.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
declare -- declare variable n, i and j-- of datatype number n number : = 7; i number; j number; begin for i in 1..n loop for j in 1..i loop dbms_output.put('*'); end loop; dbms_output.new_line; end loop; end; |
*
**
***
****
*****
******
*******
If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.