Home » SQL & PL/SQL » SQL & PL/SQL » what is a loop? plz help
what is a loop? plz help [message #36692] Wed, 12 December 2001 21:18 Go to next message
johnny o'reilly
Messages: 2
Registered: December 2001
Junior Member
can someone please explain to me in normal terms what a loop is and what it does


Re: what is a loop? plz help [message #36697 is a reply to message #36692] Thu, 13 December 2001 06:18 Go to previous message
Messages: 16
Registered: October 2001
Junior Member
Loops are iterative control structures in PL/SQL.
They help you execute a set of commands repeatedly until the desired condition is met.

The types of loops are -

1. Simple or Infinite loops
2. For Loops used for cursors or numeric counters
3. While Loops

Each has distinct properties that determine when they be activated, how many times they will be executed and the termination condition.

Any PL/SQL book will give you an exhaustive explanation on the types and use of different loops. Even if you search for 'types of loops in PL/SQL' on any search engine, you will find articles.

Good Luck!

Previous Topic: what does := mean and do
Next Topic: PL/SQL and API's
Goto Forum:

Current Time: Sat May 25 08:42:57 CDT 2024