{"id":3175,"date":"2008-11-30T10:24:00","date_gmt":"2008-11-30T10:24:00","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3175"},"modified":"2021-07-12T10:06:48","modified_gmt":"2021-07-12T10:06:48","slug":"cursors-of-the-database-in-oracle-11g","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/","title":{"rendered":"Cursors of the database in Oracle 11g"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" style=\"text-align:center\"><strong>ABSTRACT<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/SQL uses both implicit and explicit cursors. PL\/SQL implicitly declares a cursor for all SQL data manipulation statements on a set of rows, including queries that return only one row. If we want precise control over query processing, we can declare an explicit cursor. We must declare an explicit cursor for queries that return more than one row. Cursor variables (REF cursors) are like pointers to result sets. We use them when we want to perform a query in one subprogram, and process the results in a different subprogram (possibly one written in a different language).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Using dynamic SQL, we can build SQL statements dynamically at runtime and we can create more general purpose, flexible applications because the full text of a SQL statement may be unknown at compilation. We can use &#8220;old&#8221; package DBMS_SQL or &#8220;new&#8221; native dynamic SQL. In Oracle 11g we can use new features DBMS_SQL.TO_CURSOR_NUMBER and DBMS_SQL.TO_REFCURSOR to convert a REF cursor to DBMS_SQL cursor and vice versa.<\/p>\n\n\n<div class=\"more\"><a href=\"http:\/\/www.istratech.hr\/wp-content\/uploads\/2008\/11\/case2008.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Database cursor is a name for a specific private SQL area in which information for processing the specific statement is kept.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_themeisle_gutenberg_block_has_review":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[172,329,330],"tags":[],"class_list":["post-3175","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-case-en","category-conferences"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cursors of the database in Oracle 11g &#8211; Istra Tech<\/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:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cursors of the database in Oracle 11g &#8211; Istra Tech\" \/>\n<meta property=\"og:description\" content=\"Database cursor is a name for a specific private SQL area in which information for processing the specific statement is kept.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-30T10:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-12T10:06:48+00:00\" \/>\n<meta name=\"author\" content=\"Istratech Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Istratech Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"Cursors of the database in Oracle 11g\",\"datePublished\":\"2008-11-30T10:24:00+00:00\",\"dateModified\":\"2021-07-12T10:06:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/\"},\"wordCount\":185,\"commentCount\":0,\"articleSection\":[\"Blog\",\"CASE\",\"Conferences\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/\",\"name\":\"Cursors of the database in Oracle 11g &#8211; Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2008-11-30T10:24:00+00:00\",\"dateModified\":\"2021-07-12T10:06:48+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/cursors-of-the-database-in-oracle-11g\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cursors of the database in Oracle 11g\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/\",\"name\":\"Istra Tech\",\"description\":\"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\",\"name\":\"Istratech Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"caption\":\"Istratech Admin\"},\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/author\\\/istratech_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cursors of the database in Oracle 11g &#8211; Istra Tech","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.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/","og_locale":"en_US","og_type":"article","og_title":"Cursors of the database in Oracle 11g &#8211; Istra Tech","og_description":"Database cursor is a name for a specific private SQL area in which information for processing the specific statement is kept.","og_url":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/","og_site_name":"Istra Tech","article_published_time":"2008-11-30T10:24:00+00:00","article_modified_time":"2021-07-12T10:06:48+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"Cursors of the database in Oracle 11g","datePublished":"2008-11-30T10:24:00+00:00","dateModified":"2021-07-12T10:06:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/"},"wordCount":185,"commentCount":0,"articleSection":["Blog","CASE","Conferences"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/","url":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/","name":"Cursors of the database in Oracle 11g &#8211; Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2008-11-30T10:24:00+00:00","dateModified":"2021-07-12T10:06:48+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/cursors-of-the-database-in-oracle-11g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"Cursors of the database in Oracle 11g"}]},{"@type":"WebSite","@id":"https:\/\/www.istratech.hr\/en\/#website","url":"https:\/\/www.istratech.hr\/en\/","name":"Istra Tech","description":"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istratech.hr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d","name":"Istratech Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","caption":"Istratech Admin"},"url":"https:\/\/www.istratech.hr\/en\/author\/istratech_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/comments?post=3175"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3175\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}