{"id":13576,"date":"2024-03-15T07:24:06","date_gmt":"2024-03-15T07:24:06","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/"},"modified":"2025-08-05T20:27:32","modified_gmt":"2025-08-05T20:27:32","slug":"how-is-the-usage-of-the-for-loop-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/","title":{"rendered":"Oracle FOR Loop: Usage Guide & Examples"},"content":{"rendered":"

In Oracle, there are two ways to perform loops.<\/p>\n

    \n
  1. Using a FOR loop: A FOR loop is a type of loop statement that controls the number of times a loop is executed by specifying the initial value, ending value, and step size of a loop variable. The syntax is as follows:<\/li>\n
  2. FOR loop_variable IN start_value..end_value LOOP
    \n — Code to be executed
    \nEND LOOP;<\/li>\n
  3. For example, the following example demonstrates printing numbers from 1 to 10 using a FOR loop.<\/li>\n
  4. DECLARE
    \n i INTEGER;
    \nBEGIN
    \n FOR i IN 1 TO 10 LOOP
    \n DBMS_OUTPUT.PUT_LINE(i);
    \n END LOOP;
    \nEND;<\/li>\n
  5. Within the loop, you can execute any SQL statements, PL\/SQL code, or call stored procedures.<\/li>\n
  6. Using a WHILE loop: A WHILE loop is a type of conditional loop statement that will continue to execute as long as the specified condition is true. The syntax is as follows:<\/li>\n
  7. LOOP WHILE condition
    \n — Code to be executed
    \nEND LOOP;<\/li>\n
  8. For example, the following example demonstrates how to use a WHILE loop to print numbers from 1 to 10.<\/li>\n
  9. Declare a variable “i” equal to 1. Loop through and display numbers 1 through 10 using a DBMS output. Increment the value of “i” by 1 in each iteration.<\/li>\n
  10. Within the loop body, you can execute any SQL statements, PL\/SQL code, or call stored procedures.<\/li>\n<\/ol>\n

    Whether using a FOR loop or a WHILE loop, it is important to ensure that the code within the loop is able to move the loop variable towards the end value, otherwise it may result in an infinite loop.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In Oracle, there are two ways to perform loops. Using a FOR loop: A FOR loop is a type of loop statement that controls the number of times a loop is executed by specifying the initial value, ending value, and step size of a loop variable. The syntax is as follows: FOR loop_variable IN start_value..end_value […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[90,18106,18098,3302,11107],"class_list":["post-13576","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-programming","tag-loop-syntax","tag-oracle-for-loop","tag-oracle-pl-sql","tag-pl-sql-loops"],"yoast_head":"\nOracle FOR Loop: Usage Guide & Examples - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Master Oracle FOR loop syntax and usage. Includes practical PL\/SQL examples for efficient database programming.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle FOR Loop: Usage Guide & Examples\" \/>\n<meta property=\"og:description\" content=\"Master Oracle FOR loop syntax and usage. Includes practical PL\/SQL examples for efficient database programming.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T07:24:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T20:27:32+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"Oracle FOR Loop: Usage Guide & Examples\",\"datePublished\":\"2024-03-15T07:24:06+00:00\",\"dateModified\":\"2025-08-05T20:27:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\"},\"wordCount\":260,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database programming\",\"Loop syntax\",\"oracle for loop\",\"Oracle PL\/SQL\",\"PL\/SQL loops\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\",\"name\":\"Oracle FOR Loop: Usage Guide & Examples - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:24:06+00:00\",\"dateModified\":\"2025-08-05T20:27:32+00:00\",\"description\":\"Master Oracle FOR loop syntax and usage. Includes practical PL\/SQL examples for efficient database programming.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle FOR Loop: Usage Guide & Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle FOR Loop: Usage Guide & Examples - Blog - Silicon Cloud","description":"Master Oracle FOR loop syntax and usage. Includes practical PL\/SQL examples for efficient database programming.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Oracle FOR Loop: Usage Guide & Examples","og_description":"Master Oracle FOR loop syntax and usage. Includes practical PL\/SQL examples for efficient database programming.","og_url":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:24:06+00:00","article_modified_time":"2025-08-05T20:27:32+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"Oracle FOR Loop: Usage Guide & Examples","datePublished":"2024-03-15T07:24:06+00:00","dateModified":"2025-08-05T20:27:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/"},"wordCount":260,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database programming","Loop syntax","oracle for loop","Oracle PL\/SQL","PL\/SQL loops"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/","name":"Oracle FOR Loop: Usage Guide & Examples - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:24:06+00:00","dateModified":"2025-08-05T20:27:32+00:00","description":"Master Oracle FOR loop syntax and usage. Includes practical PL\/SQL examples for efficient database programming.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-usage-of-the-for-loop-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle FOR Loop: Usage Guide & Examples"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13576"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13576\/revisions"}],"predecessor-version":[{"id":157570,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13576\/revisions\/157570"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}