Multiplication of table. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Multiplication of table.

Author

Topic

Irfan.abdullah
Starting Member

9 Posts

Posted - 2012-09-20 : 19:57:17

Hi,

Im making a multiplication table for 5 and 6. im using this statement:

declare
a number(2):=5;
b number(2):=6;
c number(2);
begin
for c in 1..5
loop
dbms_output.put_line(a||'*'||c||' = '||a*c);
dbms_output.put_line(b||'*'||c||' = '||b*c);
end loop;
end;
/
My required results are:
5 * 1 = 5
5 * 2 = 10
5 * 3 = 15
5 * 4 = 20
5 * 5 = 25
6 * 1 = 6
6 * 2 = 12
6 * 3 = 18
6 * 4 = 24
6 * 5 = 30

Im getting

5 * 1 = 5
6 * 1 = 6
5 * 2 = 10
6 * 2 = 12.....

Any idea how I can fix this?

I tried:
declare
a number(2):=5;
b number(2):=6;
c number(2);
begin
for c in 1..5
loop
dbms_output.put_line(a||'*'||c||' = '||a*c);
end loop;
loop
dbms_output.put_line(b||'*'||c||' = '||b*c);
end loop;
end;
But this statement just hangs... it never shows the results.. froze my PC twice..

THanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-09-20 : 20:39:06

For Oracle questions, please post at dbforums.com

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources