{"id":638,"date":"2026-07-23T05:54:23","date_gmt":"2026-07-23T05:54:23","guid":{"rendered":"https:\/\/mitalgoswami.in\/?p=638"},"modified":"2026-07-23T05:56:34","modified_gmt":"2026-07-23T05:56:34","slug":"nested-tables-in-oracle","status":"publish","type":"post","link":"https:\/\/mitalgoswami.in\/?p=638","title":{"rendered":"Nested Tables in Oracle"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">What is a Nested Table?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A <strong>Nested Table<\/strong> is an Oracle collection type that stores <strong>multiple values of the same data type<\/strong> in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has <strong>no fixed size<\/strong> and can grow dynamically.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is useful when one record needs to store multiple related values, such as a student having multiple subjects or an employee having multiple 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 Nested Tables<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Stores multiple elements of the same data type.<\/li>\n\n\n\n<li>Has <strong>no maximum size<\/strong> (dynamic).<\/li>\n\n\n\n<li>Elements can be <strong>inserted, updated, and deleted<\/strong>.<\/li>\n\n\n\n<li>Can be stored in a database table or used in PL\/SQL.<\/li>\n\n\n\n<li>Supports collection methods such as <code>COUNT<\/code>, <code>EXTEND<\/code>, <code>DELETE<\/code>, <code>FIRST<\/code>, <code>LAST<\/code>, and <code>EXISTS<\/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<h3 class=\"wp-block-heading\">1. Create a Nested Table Type<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TYPE type_name AS TABLE OF datatype;\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. Declare a Variable<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>variable_name type_name;<\/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: Nested Table in PL\/SQL<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    TYPE marks_tab IS TABLE OF NUMBER;\n\n    marks marks_tab := marks_tab(80, 85, 90, 95);\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<\/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: Adding Elements Using EXTEND<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    TYPE names_tab IS TABLE OF VARCHAR2(30);\n\n    names names_tab := names_tab();\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<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 3: Deleting an Element<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    TYPE num_tab IS TABLE OF NUMBER;\n\n    nums num_tab := num_tab(10,20,30,40);\n\nBEGIN\n    nums.DELETE(2);\n\n    FOR i IN nums.FIRST .. nums.LAST LOOP\n        IF nums.EXISTS(i) THEN\n            DBMS_OUTPUT.PUT_LINE(nums(i));\n        END IF;\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>10\n30\n40<\/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 4: Nested Table as a Column<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Create Nested Table Type<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TYPE phone_list AS TABLE OF VARCHAR2(15);\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Create Table<\/h3>\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_list\n)\nNESTED TABLE PHONE_NUMBERS STORE AS PHONE_STORE;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Insert Data<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO CUSTOMER\nVALUES\n(\n    101,\n    'Rahul',\n    phone_list('9876543210','9123456789')\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\">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 number of elements<\/td><\/tr><tr><td><code>EXTEND<\/code><\/td><td>Adds new element(s)<\/td><\/tr><tr><td><code>DELETE<\/code><\/td><td>Removes elements<\/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><tr><td><code>EXISTS(n)<\/code><\/td><td>Checks whether element <code>n<\/code> exists<\/td><\/tr><tr><td><code>TRIM<\/code><\/td><td>Removes element(s) from the end<\/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\">Nested Table vs VARRAY<\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Feature<\/th><th>Nested Table<\/th><th>VARRAY<\/th><\/tr><\/thead><tbody><tr><td>Maximum Size<\/td><td>Unlimited<\/td><td>Fixed maximum size<\/td><\/tr><tr><td>Size<\/td><td>Dynamic<\/td><td>Fixed at creation<\/td><\/tr><tr><td>Delete Individual Elements<\/td><td>Yes<\/td><td>No (only TRIM from end)<\/td><\/tr><tr><td>Storage<\/td><td>Can be stored separately<\/td><td>Stored inline (or as LOB for large arrays)<\/td><\/tr><tr><td>Best Use<\/td><td>Large, variable-sized collections<\/td><td>Small, fixed-size collections<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such [&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":[],"class_list":["post-638","post","type-post","status-publish","format-standard","hentry","category-oracle"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such\" \/>\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=638\" \/>\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=\"Nested Tables in Oracle - Mital&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mitalgoswami.in\/?p=638\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-23T05:54:23+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-23T05:56:34+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Nested Tables in Oracle - Mital&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such\" \/>\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=638#blogposting\",\"name\":\"Nested Tables in Oracle - Mital's Blog\",\"headline\":\"Nested Tables in Oracle\",\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\"},\"datePublished\":\"2026-07-23T05:54:23+00:00\",\"dateModified\":\"2026-07-23T05:56:34+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=638#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=638#webpage\"},\"articleSection\":\"oracle\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=638#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=638#listItem\",\"name\":\"Nested Tables in Oracle\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=638#listItem\",\"position\":3,\"name\":\"Nested Tables in Oracle\",\"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=638#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=638#webpage\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=638\",\"name\":\"Nested Tables in Oracle - Mital's Blog\",\"description\":\"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\\\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=638#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"datePublished\":\"2026-07-23T05:54:23+00:00\",\"dateModified\":\"2026-07-23T05:56:34+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":"Nested Tables in Oracle - Mital's Blog","description":"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such","canonical_url":"https:\/\/mitalgoswami.in\/?p=638","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mitalgoswami.in\/?p=638#blogposting","name":"Nested Tables in Oracle - Mital's Blog","headline":"Nested Tables in Oracle","author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"publisher":{"@id":"https:\/\/mitalgoswami.in\/#organization"},"datePublished":"2026-07-23T05:54:23+00:00","dateModified":"2026-07-23T05:56:34+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mitalgoswami.in\/?p=638#webpage"},"isPartOf":{"@id":"https:\/\/mitalgoswami.in\/?p=638#webpage"},"articleSection":"oracle"},{"@type":"BreadcrumbList","@id":"https:\/\/mitalgoswami.in\/?p=638#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=638#listItem","name":"Nested Tables in Oracle"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?p=638#listItem","position":3,"name":"Nested Tables in Oracle","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=638#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=638#webpage","url":"https:\/\/mitalgoswami.in\/?p=638","name":"Nested Tables in Oracle - Mital's Blog","description":"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mitalgoswami.in\/#website"},"breadcrumb":{"@id":"https:\/\/mitalgoswami.in\/?p=638#breadcrumblist"},"author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"creator":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"datePublished":"2026-07-23T05:54:23+00:00","dateModified":"2026-07-23T05:56:34+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":"Nested Tables in Oracle - Mital's Blog","og:description":"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such","og:url":"https:\/\/mitalgoswami.in\/?p=638","article:published_time":"2026-07-23T05:54:23+00:00","article:modified_time":"2026-07-23T05:56:34+00:00","twitter:card":"summary_large_image","twitter:title":"Nested Tables in Oracle - Mital's Blog","twitter:description":"What is a Nested Table? A Nested Table is an Oracle collection type that stores multiple values of the same data type in a single column or PL\/SQL variable. Unlike VARRAYs, a nested table has no fixed size and can grow dynamically. It is useful when one record needs to store multiple related values, such"},"aioseo_meta_data":{"post_id":"638","title":"#post_title #separator_sa #site_title","description":"#post_excerpt","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:54:24","updated":"2026-07-24 04:48:56","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\tNested Tables in Oracle\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/mitalgoswami.in"},{"label":"oracle","link":"https:\/\/mitalgoswami.in\/?cat=30"},{"label":"Nested Tables in Oracle","link":"https:\/\/mitalgoswami.in\/?p=638"}],"_links":{"self":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/638","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=638"}],"version-history":[{"count":1,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions"}],"predecessor-version":[{"id":639,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions\/639"}],"wp:attachment":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}