Announcement

Collapse
No announcement yet.

SQL Help !!!!

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Help !!!!

    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
Working...
X