Home » SQL & PL/SQL » SQL & PL/SQL » nested loops
nested loops [message #18778] Thu, 14 February 2002 00:06 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
What are nested loops?

Report message to a moderator

Re: nested loops [message #18785 is a reply to message #18778] Thu, 14 February 2002 00:37 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
loop within the loop

ex.

declare
begin
for i in 1..3
loop
for j in 1..3
loop
dbms_output.put_line(to_char(i)||'--'||to_char(j));
end loop;
end loop;
end;
/

Report message to a moderator

Previous Topic: Re: Explain plan
Next Topic: database trigger to restrict deleting
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 13:17:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.