You have given a number n then you have to print number a right-angled pyramid of *
Examples:
Input : 3 Output : * ** *** Input : 7 Output : * ** *** **** ***** ****** *******
declare -- declare variable n, i and j-- of datatype number n number : = 7; i number; j number; begin -- loop from 1 to n for i in 1..n loop for j in 1..i loop -- printing * dbms_output.put('*'); end loop; -- for new line dbms_output.new_line; end loop; end; --Program End |
Output:
* ** *** **** ***** ****** *******
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
Recommended Posts:
- Programs to print Interesting Patterns
- Program to print solid and hollow square patterns
- Program to print solid and hollow rhombus patterns
- Program to print hollow rectangle or square star patterns
- Program to print right and left arrow patterns
- Print different star patterns in SQL
- Program to print diagonal star patterns
- Recursive program to print triangular patterns
- Programs to print Triangle and Diamond patterns using recursion
- PLSQL | LOG Function
- PLSQL | INSTR Function
- PLSQL | INSTRB Function
- PLSQL | LENGTH2 Function
- Difference between SQL and PLSQL
- PLSQL | SOUNDEX Function
- PLSQL | ASCII Function
- PLSQL | CONCAT Function
- PLSQL | COMPOSE Function
- PLSQL | CHR Function
- PLSQL | ASCIISTR Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.

