{"id":1585,"date":"2017-11-28T20:34:03","date_gmt":"2017-11-28T13:34:03","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=1585"},"modified":"2025-05-25T03:12:37","modified_gmt":"2025-05-25T10:12:37","slug":"plsql-cursor-with-parameters","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/","title":{"rendered":"PL\/SQL Cursor with Parameters"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the PL\/SQL cursor with parameters to fetch data based on parameters.<\/p>\n\n\n\n<p>An <a href=\"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor\/\">explicit cursor<\/a> may accept a list of parameters. Each time you open the cursor, you can pass different arguments to the cursor, which results in different result sets.<\/p>\n\n\n\n<p>Here&#8217;s the syntax of a declaring a cursor with parameters:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">CURSOR cursor_name (parameter_list) \nIS\ncursor_query;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In the cursor query, each parameter in the parameter list can be used anywhere which a constant is used. The cursor parameters cannot be referenced outside of the cursor query.<\/p>\n\n\n\n<p>To open a cursor with parameters, you use the following syntax:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">OPEN cursor_name (value_list);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax, you passed arguments corresponding to the parameters of the cursor.<\/p>\n\n\n\n<p>Cursors with parameters are also known as <strong>parameterized cursors<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='plsql-cursor-with-parameters-example'>PL\/SQL cursor with parameters example <a href=\"#plsql-cursor-with-parameters-example\" class=\"anchor\" id=\"plsql-cursor-with-parameters-example\" title=\"Anchor for PL\/SQL cursor with parameters example\">#<\/a><\/h2>\n\n\n\n<p>We&#8217;ll use the products table from the sample database:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"144\" height=\"165\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2017\/07\/products-table.png\" alt=\"products table\" class=\"wp-image-247\"\/><\/figure>\n\n\n\n<p>The following example illustrates how to use a cursor with parameters:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span>\n    r_product products%rowtype;\n    CURSOR c_product (low_price NUMBER, high_price NUMBER)\n    IS\n        <span class=\"hljs-keyword\">SELECT<\/span> *\n        <span class=\"hljs-keyword\">FROM<\/span> products\n        <span class=\"hljs-keyword\">WHERE<\/span> list_price <span class=\"hljs-keyword\">BETWEEN<\/span> low_price <span class=\"hljs-keyword\">AND<\/span> high_price;\n<span class=\"hljs-keyword\">BEGIN<\/span>\n    <span class=\"hljs-comment\">-- show mass products<\/span>\n    dbms_output.put_line(<span class=\"hljs-string\">'Mass products: '<\/span>);\n    OPEN c_product(50,100);\n    LOOP\n        FETCH c_product INTO r_product;\n        EXIT WHEN c_product%notfound;\n        dbms_output.put_line(r_product.product_name || ': ' ||r_product.list_price);\n    <span class=\"hljs-keyword\">END<\/span> <span class=\"hljs-keyword\">LOOP<\/span>;\n    CLOSE c_product;\n\n    <span class=\"hljs-comment\">-- show luxury products<\/span>\n    dbms_output.put_line('Luxury products: ');\n    OPEN c_product(800,1000);\n    LOOP\n        FETCH c_product INTO r_product;\n        EXIT WHEN c_product%notfound;\n        dbms_output.put_line(r_product.product_name || ': ' ||r_product.list_price);\n    <span class=\"hljs-keyword\">END<\/span> <span class=\"hljs-keyword\">LOOP<\/span>;\n    CLOSE c_product;\n\n<span class=\"hljs-keyword\">END<\/span>;\n\/<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">Intel SSDPECME040T401: $8867.99\nPNY VCQP6000-PB: $5499.99\nPNY VCQM6000-24GB-PB: $4139\nIntel Xeon E5-2699 V3 (OEM\/Tray): $3410.46\n...<\/code><\/span><\/pre>\n\n\n<p>In this example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, declare a cursor that accepts two parameters low and high prices. The cursor retrieves products with the prices between the low and high.<\/li>\n\n\n\n<li>Second, open the cursor and pass the low and high prices as 50 and 100 respectively. Then fetch each row in the cursor show the product&#8217;s information, and close the cursor.<\/li>\n\n\n\n<li>Third, open the cursor for the second time but with different arguments, 800 for the low price and 100 for the high price. Then the rest is fetching data, printing out the product&#8217;s information, and closing the cursor.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id='plsql-parameterized-cursor-with-default-values'>PL\/SQL parameterized cursor with default values <a href=\"#plsql-parameterized-cursor-with-default-values\" class=\"anchor\" id=\"plsql-parameterized-cursor-with-default-values\" title=\"Anchor for PL\/SQL parameterized cursor with default values\">#<\/a><\/h2>\n\n\n\n<p>A parameterized cursor can have default values for its parameters as shown below:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">CURSOR cursor_name (\n    parameter_name datatype := default_value, \n    parameter_name datatype := default_value, \n    ...\n) IS \n    cursor_query;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>If you open the parameterized cursor without passing any argument, the cursor will use the default values for its parameters.<\/p>\n\n\n\n<p>The following example shows how to use a parameterized cursor with default values.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span>\n    <span class=\"hljs-keyword\">CURSOR<\/span> c_revenue (in_year <span class=\"hljs-built_in\">NUMBER<\/span> :=<span class=\"hljs-number\">2017<\/span> , in_customer_id <span class=\"hljs-built_in\">NUMBER<\/span> := <span class=\"hljs-number\">1<\/span>)\n    <span class=\"hljs-keyword\">IS<\/span>\n        <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">SUM<\/span>(quantity * unit_price) revenue\n        <span class=\"hljs-keyword\">FROM<\/span> order_items\n        <span class=\"hljs-keyword\">INNER<\/span> <span class=\"hljs-keyword\">JOIN<\/span> orders <span class=\"hljs-keyword\">USING<\/span> (order_id)\n        <span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">status<\/span> = <span class=\"hljs-string\">'Shipped'<\/span> <span class=\"hljs-keyword\">AND<\/span> <span class=\"hljs-keyword\">EXTRACT<\/span>( <span class=\"hljs-keyword\">YEAR<\/span> <span class=\"hljs-keyword\">FROM<\/span> order_date) = in_year\n        <span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> customer_id\n        <span class=\"hljs-keyword\">HAVING<\/span> customer_id = in_customer_id;\n        \n    r_revenue c_revenue%rowtype;\n<span class=\"hljs-keyword\">BEGIN<\/span>\n    <span class=\"hljs-keyword\">OPEN<\/span> c_revenue;\n    LOOP\n        FETCH c_revenue INTO r_revenue;\n        EXIT    WHEN c_revenue%notfound;\n        <span class=\"hljs-comment\">-- show the revenue<\/span>\n        dbms_output.put_line(r_revenue.revenue);\n    <span class=\"hljs-keyword\">END<\/span> <span class=\"hljs-keyword\">LOOP<\/span>;\n    CLOSE c_revenue;\n<span class=\"hljs-keyword\">END<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">2406081<span class=\"hljs-selector-class\">.53<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this example, we declared a parameterized cursor with default values. When we opened the cursor, we did not pass any arguments; therefore, the cursor used the default values, 2017 for &nbsp;<code>in_year<\/code><em>&nbsp;<\/em>and 1 for <code>in_customer_id<\/code>.<\/p>\n\n\n\n<p>Now, you should know how to use a PL\/SQL cursor with parameters to fetch data from the database tables.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"1585\"\n\t\t\t\tdata-post-url=\"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/\"\n\t\t\t\tdata-post-title=\"PL\/SQL Cursor with Parameters\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"1585\"\n\t\t\t\tdata-post-url=\"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/\"\n\t\t\t\tdata-post-title=\"PL\/SQL Cursor with Parameters\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial shows you how to use the PL\/SQL cursor with parameters to fetch data based on parameters.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1418,"menu_order":23,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1585","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PL\/SQL Cursor with Parameters<\/title>\n<meta name=\"description\" content=\"This tutorial shows you how to use the PL\/SQL cursor with parameters to fetch data based on parameters.\" \/>\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.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PL\/SQL Cursor with Parameters\" \/>\n<meta property=\"og:description\" content=\"This tutorial shows you how to use the PL\/SQL cursor with parameters to fetch data based on parameters.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-25T10:12:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2017\/07\/products-table.png\" \/>\n\t<meta property=\"og:image:width\" content=\"144\" \/>\n\t<meta property=\"og:image:height\" content=\"165\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/\",\"url\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/\",\"name\":\"PL\\\/SQL Cursor with Parameters\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.oracletutorial.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/products-table.png\",\"datePublished\":\"2017-11-28T13:34:03+00:00\",\"dateModified\":\"2025-05-25T10:12:37+00:00\",\"description\":\"This tutorial shows you how to use the PL\\\/SQL cursor with parameters to fetch data based on parameters.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.oracletutorial.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/products-table.png\",\"contentUrl\":\"https:\\\/\\\/www.oracletutorial.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/products-table.png\",\"width\":144,\"height\":165,\"caption\":\"products table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/plsql-cursor-with-parameters\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.oracletutorial.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PL\\\/SQL Tutorial\",\"item\":\"https:\\\/\\\/www.oracletutorial.com\\\/plsql-tutorial\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PL\\\/SQL Cursor with Parameters\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/#website\",\"url\":\"https:\\\/\\\/www.oracletutorial.com\\\/\",\"name\":\"Oracle Tutorial\",\"description\":\"Oracle Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.oracletutorial.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PL\/SQL Cursor with Parameters","description":"This tutorial shows you how to use the PL\/SQL cursor with parameters to fetch data based on parameters.","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.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/","og_locale":"en_US","og_type":"article","og_title":"PL\/SQL Cursor with Parameters","og_description":"This tutorial shows you how to use the PL\/SQL cursor with parameters to fetch data based on parameters.","og_url":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/","og_site_name":"Oracle Tutorial","article_modified_time":"2025-05-25T10:12:37+00:00","og_image":[{"width":144,"height":165,"url":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2017\/07\/products-table.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/","url":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/","name":"PL\/SQL Cursor with Parameters","isPartOf":{"@id":"https:\/\/www.oracletutorial.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/#primaryimage"},"image":{"@id":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2017\/07\/products-table.png","datePublished":"2017-11-28T13:34:03+00:00","dateModified":"2025-05-25T10:12:37+00:00","description":"This tutorial shows you how to use the PL\/SQL cursor with parameters to fetch data based on parameters.","breadcrumb":{"@id":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/#primaryimage","url":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2017\/07\/products-table.png","contentUrl":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2017\/07\/products-table.png","width":144,"height":165,"caption":"products table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-cursor-with-parameters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oracletutorial.com\/"},{"@type":"ListItem","position":2,"name":"PL\/SQL Tutorial","item":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/"},{"@type":"ListItem","position":3,"name":"PL\/SQL Cursor with Parameters"}]},{"@type":"WebSite","@id":"https:\/\/www.oracletutorial.com\/#website","url":"https:\/\/www.oracletutorial.com\/","name":"Oracle Tutorial","description":"Oracle Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oracletutorial.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages\/1585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/comments?post=1585"}],"version-history":[{"count":0,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages\/1585\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages\/1418"}],"wp:attachment":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/media?parent=1585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}