{"id":632,"date":"2026-07-23T05:47:12","date_gmt":"2026-07-23T05:47:12","guid":{"rendered":"https:\/\/mitalgoswami.in\/?p=632"},"modified":"2026-07-23T05:57:01","modified_gmt":"2026-07-23T05:57:01","slug":"type-and-rowtype-in-oracle","status":"publish","type":"post","link":"https:\/\/mitalgoswami.in\/?p=632","title":{"rendered":"%type and %rowtype in oracle"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In Oracle PL\/SQL, <strong><code>%TYPE<\/code><\/strong> and <strong><code>%ROWTYPE<\/code><\/strong> are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">1. <code>%TYPE<\/code> Attribute<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Definition<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>%TYPE<\/code> is used to declare a variable with the <strong>same data type as a table column or another variable<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Syntax<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>variable_name table_name.column_name%TYPE;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Example 1: Using <code>%TYPE<\/code><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Suppose we have an <code>EMPLOYEE<\/code> table.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>EMP_ID<\/th><th>EMP_NAME<\/th><th>SALARY<\/th><\/tr><\/thead><tbody><tr><td>101<\/td><td>Rahul<\/td><td>35000<\/td><\/tr><tr><td>102<\/td><td>Priya<\/td><td>42000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    v_name EMPLOYEE.EMP_NAME%TYPE;\n    v_salary EMPLOYEE.SALARY%TYPE;\nBEGIN\n    SELECT EMP_NAME, SALARY\n    INTO v_name, v_salary\n    FROM EMPLOYEE\n    WHERE EMP_ID = 101;\n\n    DBMS_OUTPUT.PUT_LINE('Employee Name : ' || v_name);\n    DBMS_OUTPUT.PUT_LINE('Salary : ' || v_salary);\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>Employee Name : Rahul\nSalary : 35000<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Advantages of <code>%TYPE<\/code><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Automatically inherits the column&#8217;s data type.<\/li>\n\n\n\n<li>No need to specify VARCHAR2, NUMBER, DATE, etc.<\/li>\n\n\n\n<li>If the column data type changes, PL\/SQL code doesn&#8217;t require modification.<\/li>\n\n\n\n<li>Reduces programming errors.<\/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\">2. <code>%ROWTYPE<\/code> Attribute<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Definition<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>%ROWTYPE<\/code> declares a <strong>record variable<\/strong> that can hold an entire row from a table or cursor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each column becomes a field of the record.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Syntax<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>record_name table_name%ROWTYPE;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Example 2: Using <code>%ROWTYPE<\/code><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    emp_record EMPLOYEE%ROWTYPE;\nBEGIN\n    SELECT *\n    INTO emp_record\n    FROM EMPLOYEE\n    WHERE EMP_ID = 101;\n\n    DBMS_OUTPUT.PUT_LINE('ID : ' || emp_record.EMP_ID);\n    DBMS_OUTPUT.PUT_LINE('Name : ' || emp_record.EMP_NAME);\n    DBMS_OUTPUT.PUT_LINE('Salary : ' || emp_record.SALARY);\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>ID : 101\nName : Rahul\nSalary : 35000<\/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 Using INSERT with <code>%ROWTYPE<\/code><\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    emp_rec EMPLOYEE%ROWTYPE;\nBEGIN\n    emp_rec.EMP_ID := 105;\n    emp_rec.EMP_NAME := 'Riya';\n    emp_rec.SALARY := 50000;\n\n    INSERT INTO EMPLOYEE\n    VALUES emp_rec;\n\n    COMMIT;\nEND;\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 Using UPDATE<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    emp_rec EMPLOYEE%ROWTYPE;\nBEGIN\n    SELECT *\n    INTO emp_rec\n    FROM EMPLOYEE\n    WHERE EMP_ID = 101;\n\n    emp_rec.SALARY := emp_rec.SALARY + 5000;\n\n    UPDATE EMPLOYEE\n    SET SALARY = emp_rec.SALARY\n    WHERE EMP_ID = emp_rec.EMP_ID;\n\n    COMMIT;\nEND;\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\">Difference Between <code>%TYPE<\/code> and <code>%ROWTYPE<\/code><\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Feature<\/th><th><code>%TYPE<\/code><\/th><th><code>%ROWTYPE<\/code><\/th><\/tr><\/thead><tbody><tr><td>Stores<\/td><td>Single column value<\/td><td>Entire row (record)<\/td><\/tr><tr><td>Based On<\/td><td>Table column or variable<\/td><td>Whole table or cursor<\/td><\/tr><tr><td>Data Type<\/td><td>One data type<\/td><td>Collection of all column data types<\/td><\/tr><tr><td>Access<\/td><td>Direct variable<\/td><td>Record fields using dot (<code>.<\/code>) notation<\/td><\/tr><tr><td>Example<\/td><td><code>EMPLOYEE.SALARY%TYPE<\/code><\/td><td><code>EMPLOYEE%ROWTYPE<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type [&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-632","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=\"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type\" \/>\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=632\" \/>\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=\"%type and %rowtype in oracle - Mital&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mitalgoswami.in\/?p=632\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-23T05:47:12+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-23T05:57:01+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"%type and %rowtype in oracle - Mital&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type\" \/>\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=632#blogposting\",\"name\":\"%type and %rowtype in oracle - Mital's Blog\",\"headline\":\"%type and %rowtype in oracle\",\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\"},\"datePublished\":\"2026-07-23T05:47:12+00:00\",\"dateModified\":\"2026-07-23T05:57:01+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=632#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=632#webpage\"},\"articleSection\":\"oracle\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=632#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=632#listItem\",\"name\":\"%type and %rowtype in oracle\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=632#listItem\",\"position\":3,\"name\":\"%type and %rowtype 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=632#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=632#webpage\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=632\",\"name\":\"%type and %rowtype in oracle - Mital's Blog\",\"description\":\"In Oracle PL\\\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=632#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"datePublished\":\"2026-07-23T05:47:12+00:00\",\"dateModified\":\"2026-07-23T05:57:01+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":"%type and %rowtype in oracle - Mital's Blog","description":"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type","canonical_url":"https:\/\/mitalgoswami.in\/?p=632","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mitalgoswami.in\/?p=632#blogposting","name":"%type and %rowtype in oracle - Mital's Blog","headline":"%type and %rowtype in oracle","author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"publisher":{"@id":"https:\/\/mitalgoswami.in\/#organization"},"datePublished":"2026-07-23T05:47:12+00:00","dateModified":"2026-07-23T05:57:01+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mitalgoswami.in\/?p=632#webpage"},"isPartOf":{"@id":"https:\/\/mitalgoswami.in\/?p=632#webpage"},"articleSection":"oracle"},{"@type":"BreadcrumbList","@id":"https:\/\/mitalgoswami.in\/?p=632#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=632#listItem","name":"%type and %rowtype in oracle"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?p=632#listItem","position":3,"name":"%type and %rowtype 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=632#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=632#webpage","url":"https:\/\/mitalgoswami.in\/?p=632","name":"%type and %rowtype in oracle - Mital's Blog","description":"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mitalgoswami.in\/#website"},"breadcrumb":{"@id":"https:\/\/mitalgoswami.in\/?p=632#breadcrumblist"},"author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"creator":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"datePublished":"2026-07-23T05:47:12+00:00","dateModified":"2026-07-23T05:57:01+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":"%type and %rowtype in oracle - Mital's Blog","og:description":"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type","og:url":"https:\/\/mitalgoswami.in\/?p=632","article:published_time":"2026-07-23T05:47:12+00:00","article:modified_time":"2026-07-23T05:57:01+00:00","twitter:card":"summary_large_image","twitter:title":"%type and %rowtype in oracle - Mital's Blog","twitter:description":"In Oracle PL\/SQL, %TYPE and %ROWTYPE are attributes used to declare variables based on the data type of database columns or entire table rows. They make programs easier to maintain because variables automatically adapt if the table structure changes. 1. %TYPE Attribute Definition %TYPE is used to declare a variable with the same data type"},"aioseo_meta_data":{"post_id":"632","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:47:13","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\t%type and %rowtype 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":"%type and %rowtype in oracle","link":"https:\/\/mitalgoswami.in\/?p=632"}],"_links":{"self":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/632","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=632"}],"version-history":[{"count":1,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions\/633"}],"wp:attachment":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}