{"id":17154,"date":"2020-10-11T12:27:20","date_gmt":"2020-10-11T12:27:20","guid":{"rendered":"https:\/\/dbtut.com\/?p=17154"},"modified":"2020-10-11T15:32:17","modified_gmt":"2020-10-11T15:32:17","slug":"oracle-pl-sql-cursor","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/","title":{"rendered":"Oracle PL\/SQL Cursor"},"content":{"rendered":"<p>This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.<\/p>\n<h3>What is Oracle PL\/SQL Cursor?<\/h3>\n<p>When the data in a table is listed, we can read the data row by row using the cursor and we can operate on these rows.<\/p>\n<p>By using various values \u200b\u200bin the cursor, it receives information about whether it is at the end of the record list and whether there is data.<\/p>\n<h2>Oracle Cursor Types<\/h2>\n<p>There are two types of Cursors;<\/p>\n<ul>\n<li>Implicit<\/li>\n<li>Explicit<\/li>\n<\/ul>\n<h2>Implicit Cursor in PL\/SQL<\/h2>\n<p>When the database queries run, the cursor created and managed by oracle is called Implicit Cursor.<\/p>\n<p>We can not control this cursor type.<\/p>\n<pre class=\"lang:default decode:true\">BEGIN\r\n    INSERT ALL\r\n        INTO MYTABLE(COLUMN1, COLUMN2, ...) VALUES('VALUE1', 'VALUE2', ...)\r\n        INTO MYTABLE(COLUMN1, COLUMN2, ...) VALUES('VALUE1', 'VALUE2', ...)\r\n    SELECT * FROM DUAL;\r\n    DBMS_OUTPUT.put_line(SQL%ROWCOUNT);\r\n    --DBMS_OUTPUT.put_line(sql%FOUND);\r\n    --DBMS_OUTPUT.put_line(SQL%NOTFOUND);\r\n    --DBMS_OUTPUT.put_line(SQL%ISOPEN);\r\nEND;<\/pre>\n<h2>Explicit Cursor in PL\/SQL<\/h2>\n<p>This is the cursor most of us knows. We can control this cursor type.<\/p>\n<p>If we need the perform something(query execution, calculation) for all the rows of a query result set we can use cursor.<\/p>\n<p>We can define cursor as follows;<\/p>\n<pre class=\"lang:default decode:true\">CURSOR cursor_name IS query;<\/pre>\n<h4>Sample Cursor Definition;<\/h4>\n<pre class=\"lang:default decode:true\">CURSOR LIST_TABLE IS SELECT * FROM TABLE_NAME;<\/pre>\n<p>Once the cursor is defined, we open the Cursor with the OPEN keyword.<\/p>\n<pre class=\"lang:default decode:true\">OPEN cursor_name;<\/pre>\n<pre class=\"lang:default decode:true\">OPEN LIST_TABLE;<\/pre>\n<p>After opening the cursor , the values \u200b\u200bare fetched with FETCH keyword.<\/p>\n<pre class=\"lang:default decode:true\">FETCH cursor_name INTO variable_1, variable_2;<\/pre>\n<pre class=\"lang:default decode:true\">FETCH LIST_TABLE INTO variable_1, variable_2;<\/pre>\n<p>After the process is completed, we close the Cursor with the CLOSE keyword.<\/p>\n<pre class=\"lang:default decode:true\">CLOSE cursor_name;<\/pre>\n<h4>Sample Cursor Usage is as follows;<\/h4>\n<pre class=\"lang:default decode:true\">DECLARE\r\n    f\u0131rst_name contacts.f\u0131rst_name%type;\r\n    last_name contacts.last_name%type;\r\n    email contacts.ema\u0131l%type;\r\n    CURSOR LIST_CURSOR_EXAMPLE IS\r\n        SELECT first_name, last_name, email FROM contacts;\r\nBEGIN\r\n    OPEN LIST_CURSOR_EXAMPLE;\r\n\r\n    LOOP\r\n        FETCH LIST_CURSOR_EXAMPLE INTO first_name, last_name, email;\r\n            IF f\u0131rst_name = 'Yusuf' THEN\r\n                EXIT;\r\n            END IF;\r\n            DBMS_OUTPUT.put_line(first_name || ' - ' || last_name || ' - ' || email);\r\n        EXIT WHEN LIST_CURSOR_EXAMPLE%NOTFOUND;\r\n    END LOOP;\r\n\r\n    CLOSE LIST_CURSOR_EXAMPLE;\r\nEND;<\/pre>\n<p>We created the variables to be used in the DECLARE according to the table data type and a cursor and query with CURSOR.<\/p>\n<p>Then we opened a cursor in BEGIN, we ran the query step by step with LOOP and FETCH.<\/p>\n<p>Using IF in the FETCH block, we compared the value received with the cursor.<\/p>\n<p>At the end of the BEGIN , we returned the memory by closing the cursor.<\/p>\n<p>Thanks to the cursor, we had the opportunity to run PL \/ SQL commands on the data step by step.<\/p>\n<p>You can find more detailed information about below topics in the below link.<\/p>\n<p><strong><a href=\"https:\/\/dbtut.com\/index.php\/2020\/03\/19\/pl-sql-tutorial\/\" target=\"_blank\" rel=\"noopener noreferrer\">PL\/SQL Tutorial<\/a><\/strong><\/p>\n<p>You will find below topics in this article.<\/p>\n<ol>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>What is PL\/SQL<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-data-types-and-variables-and-literals\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Data Types and Variables and Literals<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-operators\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Operators<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-conditional-statements\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Conditional Statements<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-loops\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Loops<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Procedures and Procedure Parameters<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-functions\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Functions<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Cursor<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Records<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-exception\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Exception<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-trigger\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Trigger<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-packages\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Packages<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-collections\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Collections<\/strong><\/a><\/li>\n<\/ol>\n<p>You can find more information about cursor at <a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/appdev.102\/b14261\/cursor_declaration.htm\" target=\"_blank\" rel=\"noopener noreferrer\">docs.oracle.com<\/a><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_17154\" class=\"pvc_stats all  \" data-element-id=\"17154\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor. What is Oracle PL\/SQL Cursor? When the data in a table is listed, we can read the data row by row using the cursor and we can operate on these rows. By using various values \u200b\u200bin the cursor, it receives information about &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_17154\" class=\"pvc_stats all  \" data-element-id=\"17154\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":485,"featured_media":17155,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[9282,9279,10083,9111],"class_list":["post-17154","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-explicit-cursor-in-pl-sql","tag-implicit-cursor-in-pl-sql","tag-oracle-cursor-types","tag-what-is-oracle-pl-sql-cursor"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":182,"today_views":1},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle PL\/SQL Cursor - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle PL\/SQL Cursor - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-11T12:27:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-11T15:32:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"761\" \/>\n\t<meta property=\"og:image:height\" content=\"522\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yusuf SEZER\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf SEZER\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"Oracle PL\/SQL Cursor\",\"datePublished\":\"2020-10-11T12:27:20+00:00\",\"dateModified\":\"2020-10-11T15:32:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\"},\"wordCount\":393,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg\",\"keywords\":[\"Explicit Cursor in PL\/SQL\",\"implicit cursor in PL\/SQL\",\"Oracle Cursor Types\",\"what is oracle pl sql cursor\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\",\"name\":\"Oracle PL\/SQL Cursor - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg\",\"datePublished\":\"2020-10-11T12:27:20+00:00\",\"dateModified\":\"2020-10-11T15:32:17+00:00\",\"description\":\"This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg\",\"width\":761,\"height\":522},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle PL\/SQL Cursor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\",\"name\":\"Yusuf SEZER\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"caption\":\"Yusuf SEZER\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle PL\/SQL Cursor - Database Tutorials","description":"This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.","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:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/","og_locale":"en_US","og_type":"article","og_title":"Oracle PL\/SQL Cursor - Database Tutorials","og_description":"This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/","og_site_name":"Database Tutorials","article_published_time":"2020-10-11T12:27:20+00:00","article_modified_time":"2020-10-11T15:32:17+00:00","og_image":[{"width":761,"height":522,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg","type":"image\/jpeg"}],"author":"Yusuf SEZER","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf SEZER","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"Oracle PL\/SQL Cursor","datePublished":"2020-10-11T12:27:20+00:00","dateModified":"2020-10-11T15:32:17+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/"},"wordCount":393,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg","keywords":["Explicit Cursor in PL\/SQL","implicit cursor in PL\/SQL","Oracle Cursor Types","what is oracle pl sql cursor"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/","url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/","name":"Oracle PL\/SQL Cursor - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg","datePublished":"2020-10-11T12:27:20+00:00","dateModified":"2020-10-11T15:32:17+00:00","description":"This article contains information about Oracle PL\/SQL Cursor and example about PL\/SQL Cursor.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlcursor.jpg","width":761,"height":522},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle PL\/SQL Cursor"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a","name":"Yusuf SEZER","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","caption":"Yusuf SEZER"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/485"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=17154"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17154\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/17155"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=17154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=17154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=17154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}