Allen Pitts
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER