{"id":579,"date":"2023-11-21T22:01:02","date_gmt":"2023-11-21T22:01:02","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=579"},"modified":"2023-11-21T22:01:05","modified_gmt":"2023-11-21T22:01:05","slug":"control-structures","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/","title":{"rendered":"CONTROL STRUCTURES"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ordba.net\/rdbmsimages\/2.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">CONTROL STRUCTURES<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL Tutorials &#8211; CONTROL STRUCTURES<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let me remind you that Boolean means to me not TRUE\/FALSE but also NULL. This is true always.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">IF-THEN and ELSE when you have a Boolean like condition to validate the data. Try this.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; Begin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 For I in 1.. 10 loop<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 If mod(i,2) &lt;&gt; 0 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4 Dbms_output.put_line(&#8216; I am an odd number :&#8217;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 else<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6 Dbms_output.put_line(&#8216; I am an even number :&#8217;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7 End if;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8 End loop;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9* end;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; \/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an odd number :1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an even number :2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an odd number :3<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an even number :4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an odd number :5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an even number :6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an odd number :7<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an even number :8<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an odd number :9<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am an even number :10<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL procedure successfully completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let you play with IF..THEN, ELSIF..THEN and ELSE.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These control structures give more manageability with data. So we use this when we have more conditions to check to validate data or business requirement or a rule.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; begin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 for i in 1..10 loop<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 if i=3 or i=6 or i=9 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6 dbms_output.put_line(&#8216; This is divisible by 3: &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7 elsif i=2 or i=4 or i=6 or i=8 or i=10 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8 dbms_output.put_line(&#8216; This is divisible by 2: &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9 else<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10 dbms_output.put_line(&#8216; Is this a prime number?? &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11 end if;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13 end loop;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14 end;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15 \/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 2: 2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 3: 3<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 2: 4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 3: 6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 7<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 2: 8<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 3: 9<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is divisible by 2: 10<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL procedure successfully completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another example of finding prime numbers?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; ed<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Wrote file afiedt.buf<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 begin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 for i in 1..100 loop<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 if i in (1,5,7) then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4 dbms_output.put_line(&#8216; Is this a prime number?? &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 end if;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6 if i not in (1,5,7) then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7 if mod(i,3)=0 or mod(i,6)=0 or mod(i,9)=0 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8 null;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9 &#8211;dbms_output.put_line(&#8216; This is divisible by 3: &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10 elsif mod(i,2)=0 or mod(i,4)=0 or mod(i,8)=0 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11 null;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12 &#8211;dbms_output.put_line(&#8216; This is divisible by 2: &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13 elsif mod(i,5)=0 or mod(i,10)=0 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14 null;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15 &#8211;dbms_output.put_line(&#8216; This is divisible by 5: &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">16 elsif mod(i,7)=0 then<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">17 null;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18 else<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">19 dbms_output.put_line(&#8216; Is this a prime number?? &#8216;||i);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">20 end if;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">21 end if;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">22 end loop;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">23* end;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; \/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 7<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 11<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 13<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 17<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 19<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 23<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 29<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 31<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 37<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 41<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 43<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 47<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 53<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 59<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 61<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 67<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 71<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 73<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 79<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 83<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 89<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is this a prime number?? 97<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL procedure successfully completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now let us know how to declare a variable and print the value for the variable using PLSQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; ed<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Wrote file afiedt.buf<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 declare<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 v_global_name varchar2(100);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 begin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4 select global_name<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 into v_global_name<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6 from global_name;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7 dbms_output.put_line(v_global_name);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8* end;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; \/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">GENSTG<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL procedure successfully completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A variable can be declared in the declare section.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The same select statement you have used. But there is one new key word INTO.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One can assign value to the variable which is also called initialization of the variable. Let us try with an example to assign value and print that value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; set serveroutput on size 1000000<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; declare<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 l_variable number;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 begin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7 l_variable:=2;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9 dbms_output.put_line(l_variable);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11 end;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12 \/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL procedure successfully completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; ed<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Wrote file afiedt.buf<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 declare<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 l_variable number := 2;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 begin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4 dbms_output.put_line(l_variable);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5* end;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6 \/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL procedure successfully completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So you can do this way also and there are many ways. You can do all these things with nobody<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CONTROL STRUCTURES PL\/SQL Tutorials &#8211; CONTROL STRUCTURES In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN. Let me remind you that Boolean means to me not TRUE\/FALSE but also NULL. This is true always. IF-THEN and ELSE when you have a Boolean like condition to validate the data. Try this. SQL&gt; Begin 2 For &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/\"> <span class=\"screen-reader-text\">CONTROL STRUCTURES<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":567,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-579","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CONTROL STRUCTURES - Ordba<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CONTROL STRUCTURES - Ordba\" \/>\n<meta property=\"og:description\" content=\"CONTROL STRUCTURES PL\/SQL Tutorials &#8211; CONTROL STRUCTURES In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN. Let me remind you that Boolean means to me not TRUE\/FALSE but also NULL. This is true always. IF-THEN and ELSE when you have a Boolean like condition to validate the data. Try this. SQL&gt; Begin 2 For &hellip; CONTROL STRUCTURES Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-21T22:01:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T22:01:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle-img2-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"499\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/\",\"name\":\"CONTROL STRUCTURES - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-21T22:01:02+00:00\",\"dateModified\":\"2023-11-21T22:01:05+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CONTROL STRUCTURES\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CONTROL STRUCTURES - Ordba","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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/","og_locale":"en_US","og_type":"article","og_title":"CONTROL STRUCTURES - Ordba","og_description":"CONTROL STRUCTURES PL\/SQL Tutorials &#8211; CONTROL STRUCTURES In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN. Let me remind you that Boolean means to me not TRUE\/FALSE but also NULL. This is true always. IF-THEN and ELSE when you have a Boolean like condition to validate the data. Try this. SQL&gt; Begin 2 For &hellip; CONTROL STRUCTURES Read More &raquo;","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/","og_site_name":"Ordba","article_published_time":"2023-11-21T22:01:02+00:00","article_modified_time":"2023-11-21T22:01:05+00:00","og_image":[{"width":499,"height":400,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle-img2-1.jpg","type":"image\/jpeg"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/","name":"CONTROL STRUCTURES - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-21T22:01:02+00:00","dateModified":"2023-11-21T22:01:05+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/control-structures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"CONTROL STRUCTURES"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=579"}],"version-history":[{"count":1,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/579\/revisions"}],"predecessor-version":[{"id":580,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/579\/revisions\/580"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/567"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}