{"id":1436,"date":"2017-11-09T15:04:11","date_gmt":"2017-11-09T08:04:11","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=1436"},"modified":"2025-05-24T05:48:12","modified_gmt":"2025-05-24T12:48:12","slug":"plsql-loop","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-loop\/","title":{"rendered":"PL\/SQL LOOP"},"content":{"rendered":"\r\n

Summary<\/strong>: In this tutorial, you will learn how to use the PL\/SQL LOOP statement to execute a code block repeatedly until a condition is false.<\/span><\/p>\r\n\r\n\r\n\r\n

Introduction to PL\/SQL LOOP statement #<\/a><\/h2>\r\n\r\n\r\n\r\n

The PL\/SQL LOOP statement is a control structure that repeatedly executes a code block until a specific condition is true or until you manually exit the loop.<\/p>\r\n\r\n\r\n\r\n

Here’s the syntax of the PL\/SQL LOOP<\/code> statement:<\/p>\r\n\r\n\r\n

<<label>> LOOP\r\n    statements;\r\nEND<\/span> LOOP<\/span> loop_label;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\r\n\r\n\r\n
The LOOP<\/code> statement executes the statements in its body and returns control to the top of the loop. Typically, the body of the loop contains at least one EXIT<\/code> or EXIT WHEN<\/code> statement for terminating the loop. Otherwise, the loop becomes an infinite loop<\/strong>.<\/p>\r\n\r\n\r\n\r\n
The LOOP<\/code> statement can have an optional label that appears at the statement’s beginning and end.<\/p>\r\n\r\n\r\n\r\n
It is a good practice to use the LOOP<\/code> statement when:<\/p>\r\n\r\n\r\n\r\n
This structure is the most basic of all the loop constructs, including FOR LOOP<\/code><\/a> and WHILE LOOP<\/a><\/code>. This basic LOOP<\/code> statement consists of a LOOP<\/code> keyword, a loop body, and the END<\/code> LOOP<\/code> keywords.<\/p>\r\n\r\n\r\n\r\n