Here you will get pl/sql program to print table of a given number.

You can ask your queries in comment section.

1 2 3 4 5 6 7 8 9 10 11 12 13 |
declare n number; i number; begin n:=&n; for i in 1..10 loop dbms_output.put_line(n||' x '||i||' = '||n*i); end loop; end; / |

**Output**

*Enter value for n: 5*

*old 6: n:=&n;*

*new 6: n:=5;*

*5 x 1 = 5*

*5 x 2 = 10*

*5 x 3 = 15*

*5 x 4 = 20*

*5 x 5 = 25*

*5 x 6 = 30*

*5 x 7 = 35*

*5 x 8 = 40*

*5 x 9 = 45*

*5 x 10 = 50*

hey,thank ue so much 4 ue gud updates abt programing

Hi in above logic what is the need of x

It is to show multiplication sign in output, like this: 5 x 1 = 5

It just a msg and prints X symbol inthe output

i want matrix multiplycation in pl/sql

so plz go throw it

DECLARE

NUM1:=3;

NUM2:=1;

BEGIN

WHILE NUM1 <= 30

WHILE NUM2 <= 10

LOOP

DBMS_OUTPUT.PUT_LINE('3 x '||NUM2 ||=|| ||NUM1);

NUM1:= NUM1+3;

NUM2:= NUM2+1;

END LOOP;

END;

/

Hi Neeraj,

the program I’d written to view the table of suppose – 3, isn’t working correctly.

Kindly escort me & let me know the mistakes I’m making into it.

write a to print sql program 2*1?

like this

2*1=2

2*2=4

2*3=6

..

2*10=20 tell me answer

what is the meaning of old 6 and in next line new 6