Here you will get pl/sql program to print table of a given number.
You can ask your queries in comment section.
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
What is the use of n:=&n in PLSqL
old 6: n:=&n;
new 6: n:=5;
what are these old & new values?