{"id":640,"date":"2026-07-23T05:55:47","date_gmt":"2026-07-23T05:55:47","guid":{"rendered":"https:\/\/mitalgoswami.in\/?p=640"},"modified":"2026-07-24T04:49:59","modified_gmt":"2026-07-24T04:49:59","slug":"varrays-variable-size-arrays-in-oracle-pl-sql","status":"publish","type":"post","link":"https:\/\/mitalgoswami.in\/?p=640","title":{"rendered":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">What is a VARRAY?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A <strong>VARRAY (Variable-Size Array)<\/strong> is an Oracle collection type that stores a <strong>fixed maximum number of elements of the same data type<\/strong>. The actual number of elements can vary from <strong>0 up to the specified maximum size<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A VARRAY is suitable when the maximum number of values is known in advance, such as storing a student&#8217;s top 5 marks or an employee&#8217;s limited phone numbers.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Features of VARRAY<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Stores elements of the <strong>same data type<\/strong>.<\/li>\n\n\n\n<li>Has a <strong>fixed maximum size<\/strong> specified at creation.<\/li>\n\n\n\n<li>Elements are stored in <strong>order<\/strong> (indexed starting from 1).<\/li>\n\n\n\n<li>Elements are stored <strong>contiguously<\/strong> (no gaps).<\/li>\n\n\n\n<li>Supports collection methods like <code>COUNT<\/code>, <code>LIMIT<\/code>, <code>EXTEND<\/code>, <code>TRIM<\/code>, <code>FIRST<\/code>, and <code>LAST<\/code>.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Syntax<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">1. Create a VARRAY Type<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TYPE type_name AS VARRAY(max_size) OF datatype;\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Example<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TYPE marks_array AS VARRAY(5) OF NUMBER;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 1: VARRAY in PL\/SQL<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    TYPE marks_array IS VARRAY(5) OF NUMBER;\n\n    marks marks_array := marks_array(80, 85, 90, 95, 88);\n\nBEGIN\n    FOR i IN 1 .. marks.COUNT LOOP\n        DBMS_OUTPUT.PUT_LINE('Mark = ' || marks(i));\n    END LOOP;\nEND;\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Mark = 80\nMark = 85\nMark = 90\nMark = 95\nMark = 88<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 2: Using EXTEND<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    TYPE name_array IS VARRAY(3) OF VARCHAR2(30);\n\n    names name_array := name_array();\n\nBEGIN\n    names.EXTEND;\n    names(1) := 'Rahul';\n\n    names.EXTEND;\n    names(2) := 'Priya';\n\n    names.EXTEND;\n    names(3) := 'Amit';\n\n    FOR i IN 1 .. names.COUNT LOOP\n        DBMS_OUTPUT.PUT_LINE(names(i));\n    END LOOP;\nEND;\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Rahul\nPriya\nAmit<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">Example 4: VARRAY as a Table Column<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1: Create VARRAY Type<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TYPE phone_array AS VARRAY(3) OF VARCHAR2(15);\n\/<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2: Create Table<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE CUSTOMER\n(\n    CUSTOMER_ID NUMBER,\n    CUSTOMER_NAME VARCHAR2(50),\n    PHONE_NUMBERS phone_array\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3: Insert Data<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO CUSTOMER\nVALUES\n(\n    101,\n    'Rahul',\n    phone_array('9876543210','9123456789')\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Retrieve Data<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM CUSTOMER;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Collection Methods<\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Method<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><code>COUNT<\/code><\/td><td>Returns the current number of elements<\/td><\/tr><tr><td><code>LIMIT<\/code><\/td><td>Returns the maximum size of the VARRAY<\/td><\/tr><tr><td><code>EXTEND<\/code><\/td><td>Adds new element(s)<\/td><\/tr><tr><td><code>TRIM<\/code><\/td><td>Removes element(s) from the end<\/td><\/tr><tr><td><code>FIRST<\/code><\/td><td>Returns the first index<\/td><\/tr><tr><td><code>LAST<\/code><\/td><td>Returns the last index<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">VARRAY vs Nested Table<\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Feature<\/th><th>VARRAY<\/th><th>Nested Table<\/th><\/tr><\/thead><tbody><tr><td>Maximum Size<\/td><td>Fixed<\/td><td>Unlimited<\/td><\/tr><tr><td>Size<\/td><td>Variable up to the limit<\/td><td>Dynamic<\/td><\/tr><tr><td>Order<\/td><td>Preserved<\/td><td>Preserved, but gaps may occur after deletions<\/td><\/tr><tr><td>Delete Individual Elements<\/td><td>No (only <code>TRIM<\/code> from the end)<\/td><td>Yes (<code>DELETE<\/code>)<\/td><\/tr><tr><td>Storage<\/td><td>Inline (or as LOB for large arrays)<\/td><td>Stored separately in a nested table store<\/td><\/tr><tr><td>Best Use<\/td><td>Small, fixed-size collections<\/td><td>Large, variable-size collections<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Advantages<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Simple to use and maintain.<\/li>\n\n\n\n<li>Maintains the order of elements.<\/li>\n\n\n\n<li>Efficient for small collections with a known maximum size.<\/li>\n\n\n\n<li>Can be stored directly in database tables.<\/li>\n\n\n\n<li>Faster access for fixed-size collections.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Limitations<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Maximum size must be defined at creation time.<\/li>\n\n\n\n<li>Cannot exceed the specified limit.<\/li>\n\n\n\n<li>Individual elements cannot be deleted from the middle.<\/li>\n\n\n\n<li>Less suitable for large or frequently changing collections.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Applications<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Student marks (maximum 5 or 10 subjects)<\/li>\n\n\n\n<li>Employee phone numbers (limited count)<\/li>\n\n\n\n<li>Product sizes (S, M, L, XL)<\/li>\n\n\n\n<li>Weekly work schedule<\/li>\n\n\n\n<li>Top-ranked items<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[38],"class_list":["post-640","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-html"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"admin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/mitalgoswami.in\/?p=640\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Mital&#039;s Blog - My  Blog\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mitalgoswami.in\/?p=640\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-23T05:55:47+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-24T04:49:59+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#blogposting\",\"name\":\"VARRAYs (Variable-Size Arrays) in Oracle PL\\\/SQL - Mital's Blog\",\"headline\":\"VARRAYs (Variable-Size Arrays) in Oracle PL\\\/SQL\",\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\"},\"datePublished\":\"2026-07-23T05:55:47+00:00\",\"dateModified\":\"2026-07-24T04:49:59+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#webpage\"},\"articleSection\":\"oracle, html\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mitalgoswami.in\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30#listItem\",\"name\":\"oracle\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30#listItem\",\"position\":2,\"name\":\"oracle\",\"item\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#listItem\",\"name\":\"VARRAYs (Variable-Size Arrays) in Oracle PL\\\/SQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#listItem\",\"position\":3,\"name\":\"VARRAYs (Variable-Size Arrays) in Oracle PL\\\/SQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30#listItem\",\"name\":\"oracle\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\",\"name\":\"Mital's Blog\",\"description\":\"My  Blog\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a575ce1a3c064ed3befd825918c1c0457a92281570ba3e96c008e1c0af08ddc5?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#webpage\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640\",\"name\":\"VARRAYs (Variable-Size Arrays) in Oracle PL\\\/SQL - Mital's Blog\",\"description\":\"VARRAYs (Variable-Size Arrays) in Oracle PL\\\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=640#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"datePublished\":\"2026-07-23T05:55:47+00:00\",\"dateModified\":\"2026-07-24T04:49:59+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#website\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/\",\"name\":\"Mital's Blog\",\"description\":\"My  Blog\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital's Blog","description":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number","canonical_url":"https:\/\/mitalgoswami.in\/?p=640","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mitalgoswami.in\/?p=640#blogposting","name":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital's Blog","headline":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL","author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"publisher":{"@id":"https:\/\/mitalgoswami.in\/#organization"},"datePublished":"2026-07-23T05:55:47+00:00","dateModified":"2026-07-24T04:49:59+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mitalgoswami.in\/?p=640#webpage"},"isPartOf":{"@id":"https:\/\/mitalgoswami.in\/?p=640#webpage"},"articleSection":"oracle, html"},{"@type":"BreadcrumbList","@id":"https:\/\/mitalgoswami.in\/?p=640#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in#listItem","position":1,"name":"Home","item":"https:\/\/mitalgoswami.in","nextItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?cat=30#listItem","name":"oracle"}},{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?cat=30#listItem","position":2,"name":"oracle","item":"https:\/\/mitalgoswami.in\/?cat=30","nextItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?p=640#listItem","name":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?p=640#listItem","position":3,"name":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL","previousItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?cat=30#listItem","name":"oracle"}}]},{"@type":"Organization","@id":"https:\/\/mitalgoswami.in\/#organization","name":"Mital's Blog","description":"My  Blog","url":"https:\/\/mitalgoswami.in\/"},{"@type":"Person","@id":"https:\/\/mitalgoswami.in\/?author=1#author","url":"https:\/\/mitalgoswami.in\/?author=1","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/mitalgoswami.in\/?p=640#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/a575ce1a3c064ed3befd825918c1c0457a92281570ba3e96c008e1c0af08ddc5?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"WebPage","@id":"https:\/\/mitalgoswami.in\/?p=640#webpage","url":"https:\/\/mitalgoswami.in\/?p=640","name":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital's Blog","description":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mitalgoswami.in\/#website"},"breadcrumb":{"@id":"https:\/\/mitalgoswami.in\/?p=640#breadcrumblist"},"author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"creator":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"datePublished":"2026-07-23T05:55:47+00:00","dateModified":"2026-07-24T04:49:59+00:00"},{"@type":"WebSite","@id":"https:\/\/mitalgoswami.in\/#website","url":"https:\/\/mitalgoswami.in\/","name":"Mital's Blog","description":"My  Blog","inLanguage":"en-US","publisher":{"@id":"https:\/\/mitalgoswami.in\/#organization"}}]},"og:locale":"en_US","og:site_name":"Mital's Blog - My  Blog","og:type":"article","og:title":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital's Blog","og:description":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number","og:url":"https:\/\/mitalgoswami.in\/?p=640","article:published_time":"2026-07-23T05:55:47+00:00","article:modified_time":"2026-07-24T04:49:59+00:00","twitter:card":"summary_large_image","twitter:title":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL - Mital's Blog","twitter:description":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same data type. The actual number of elements can vary from 0 up to the specified maximum size. A VARRAY is suitable when the maximum number"},"aioseo_meta_data":{"post_id":"640","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-07-23 05:55:47","updated":"2026-07-24 04:50:00","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mitalgoswami.in\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mitalgoswami.in\/?cat=30\" title=\"oracle\">oracle<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tVARRAYs (Variable-Size Arrays) in Oracle PL\/SQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/mitalgoswami.in"},{"label":"oracle","link":"https:\/\/mitalgoswami.in\/?cat=30"},{"label":"VARRAYs (Variable-Size Arrays) in Oracle PL\/SQL","link":"https:\/\/mitalgoswami.in\/?p=640"}],"_links":{"self":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=640"}],"version-history":[{"count":2,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/640\/revisions"}],"predecessor-version":[{"id":642,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/640\/revisions\/642"}],"wp:attachment":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}