Hi Guys ,
Today we will discuss about the Multiplication with the help of Level --- Connect by clauses.
Query:
select :n Multiplier,level Multiplicand , :n*(level) Product from dual connect by level <=10;
-----> In this we can able to give any number's product.
Output:
Today we will discuss about the Multiplication with the help of Level --- Connect by clauses.
Query:
select :n Multiplier,level Multiplicand , :n*(level) Product from dual connect by level <=10;
-----> In this we can able to give any number's product.
Output:
| Multiplier | Multiplicand | Product |
| 3 | 1 | 3 |
| 3 | 2 | 6 |
| 3 | 3 | 9 |
| 3 | 4 | 12 |
| 3 | 5 | 15 |
| 3 | 6 | 18 |
| 3 | 7 | 21 |
| 3 | 8 | 24 |
| 3 | 9 | 27 |
| 3 | 10 | 30 |
No comments:
Post a Comment