Oracle SQL - Print Mathematical Table using connect by query

In this post, Print Mathematical  Table using connect by Query.

SELECT multiplicand||' * '||multiplier||' = '||multiplicand * multiplier math_table

  FROM (

SELECT LEVEL,

       CASE WHEN LEVEL > 10 THEN DECODE(MOD(LEVEL, 10), 0, 10, MOD(LEVEL, 10)) ELSE LEVEL END multiplicand,

       CEIL(LEVEL/10) multiplier

  FROM dual

 CONNECT BY LEVEL <= 50)

SAMPLE OUTPUT

MATH_TABLE

-----------

1 * 1 = 1

2 * 1 = 2

3 * 1 = 3

4 * 1 = 4

5 * 1 = 5

6 * 1 = 6

7 * 1 = 7

8 * 1 = 8

9 * 1 = 9

10 * 1 = 10

1 * 2 = 2

2 * 2 = 4

3 * 2 = 6

4 * 2 = 8

5 * 2 = 10

6 * 2 = 12

7 * 2 = 14

8 * 2 = 16

9 * 2 = 18

10 * 2 = 20

1 * 3 = 3

2 * 3 = 6

3 * 3 = 9

4 * 3 = 12

5 * 3 = 15

6 * 3 = 18

7 * 3 = 21

8 * 3 = 24

9 * 3 = 27

10 * 3 = 30

1 * 4 = 4

2 * 4 = 8

3 * 4 = 12

4 * 4 = 16

5 * 4 = 20

6 * 4 = 24

7 * 4 = 28

8 * 4 = 32

9 * 4 = 36

10 * 4 = 40

1 * 5 = 5

2 * 5 = 10

3 * 5 = 15

4 * 5 = 20

5 * 5 = 25

6 * 5 = 30

7 * 5 = 35

8 * 5 = 40

9 * 5 = 45

10 * 5 = 50

Thanks & Regards

R. Kalaiyarasan

+91 9944809554