Write aquery to display 5th table

5 * 1 = 5

5 * 2 = 10

5 * 3 = 15

5 * 4 = 20

5 * 5 = 25

5 * 6 = 30

5 * 7 = 35

5 * 8 = 40

5 * 9 = 45

5 *10 = 50

 

SELECT '5 * ' || rownum  || ' = ' || rownum *5 as t

FROM DUAL

CONNECT BY rownum  <= 10;

No comments:

Post a Comment