Link to home
Start Free TrialLog in
Avatar of Allen Pitts
Allen PittsFlag for United States of America

asked on

Oracle Loop

Hello expert,

Using Oracle SQL Developer ver 18.1
working on learning about PL/SQL Loops.
At
https://www.tutorialspoint.com/plsql/plsql_loops.htm
The code
DECLARE
   i number(1);
   j number(1);
BEGIN
   << outer_loop >> 
   FOR i IN 1..3 LOOP
      << inner_loop >> 
      FOR j IN 1..3 LOOP
         dbms_output.put_line('i is: '|| i || ' and j is: ' || j);
      END loop inner_loop;
   END loop outer_loop;
END;
/

is offered and says the result will be

i is: 1 and j is: 1
i is: 1 and j is: 2
i is: 1 and j is: 3
i is: 2 and j is: 1
i is: 2 and j is: 2
i is: 2 and j is: 3
i is: 3 and j is: 1
i is: 3 and j is: 2
i is: 3 and j is: 3  

PL/SQL procedure successfully completed.

But all that is output is

 PL/SQL procedure successfully completed.

Is there something that needs to be changed to get the
more complete result?

Thanks.

Allen in Dallas
ASKER CERTIFIED SOLUTION
Avatar of kaufmed
kaufmed
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allen Pitts

ASKER

Thanks