{"id":17157,"date":"2020-10-11T12:27:01","date_gmt":"2020-10-11T12:27:01","guid":{"rendered":"https:\/\/dbtut.com\/?p=17157"},"modified":"2020-10-11T15:28:38","modified_gmt":"2020-10-11T15:28:38","slug":"oracle-pl-sql-records","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/","title":{"rendered":"Oracle PL\/SQL Records"},"content":{"rendered":"<p>This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.<\/p>\n<h3>What is Record in Oracle?<\/h3>\n<p>Data types such as NUMBER, VARCHAR, VARCHAR2 in Oracle PL \/ SQL are used to store a single data.<\/p>\n<p>However, defining multiple variables related to each other makes the codes complicated.<\/p>\n<p>Record is a Composite data type used to store more than one value in a single variable.<\/p>\n<h2>Record Type in Oracle<\/h2>\n<p>Record data type definition can be <strong>table-based<\/strong>, <strong>cursor-based<\/strong> and <strong>user-defined<\/strong>.<\/p>\n<h3>Table Based Records in Oracle PL\/SQL<\/h3>\n<p>In this type of definition, Record definition is made by using TABLE_NAME% ROWDTYPE structure.<\/p>\n<p>In the example below, a record data type named PERSON has been created using some columns in the contacts table.<\/p>\n<pre class=\"lang:default decode:true\">DECLARE\r\n    PERSON contacts%ROWTYPE;\r\nBEGIN\r\n    PERSON.first_name := 'Yusuf';\r\n    PERSON.last_name := 'SEZER';\r\n    PERSON.email := 'yusufsezer@mail.com';\r\n    PERSON.phone := '+905386934533';\r\n    DBMS_OUTPUT.put_line(PERSON.first_name || ' ' || PERSON.last_name || ' - ' || PERSON.email || ' - ' || PERSON.phone);\r\nEND;<\/pre>\n<h3>Cursor Based Records in Oracle PL\/SQL<\/h3>\n<p>In this type of definition, the fields defined with Cursor are taken with CURSOR_NAME% ROWDTYPE and a record is defined.<\/p>\n<p>In the example below, the record data type named PERSON was created using the columns indicated by the LIST_TABLE cursor.<\/p>\n<pre class=\"lang:default decode:true\">DECLARE\r\n    CURSOR LIST_TABLE IS\r\n        SELECT first_name, last_name, email, phone FROM contacts;\r\n  PERSON LIST_TABLE%ROWTYPE;\r\nBEGIN\r\n  PERSON.first_name := 'Yusuf';\r\n  PERSON.last_name := 'SEZER';\r\n  PERSON.email := 'yusufsezer@mail.com';\r\n  PERSON.phone := '+905386934533';\r\n  DBMS_OUTPUT.put_line(PERSON.first_name || ' ' || PERSON.last_name || ' - ' || PERSON.email || ' - ' || PERSON.phone);\r\nEND;<\/pre>\n<h3>User Defined Records in Oracle PL\/SQL<\/h3>\n<p>In this type of definition, the variables to be included in the record are defined using the TYPE keyword.<\/p>\n<h4>Record Example in Oracle PL\/SQL<\/h4>\n<p>In the example below, using the TYPE keyword, we have defined a Record named PERSON, which contains the values of first_name, last_name, email, phone.<\/p>\n<pre class=\"lang:default decode:true\">DECLARE\r\n    TYPE PERSON IS RECORD (\r\n        first_name VARCHAR2(255),\r\n        last_name VARCHAR2(255) NOT NULL DEFAULT 'SEZER',\r\n        email VARCHAR2(255),\r\n        phone VARCHAR2(20)\r\n    );\r\n  K1 PERSON;\r\nBEGIN\r\n  K1.first_name := 'Yusuf';\r\n  -- K1.last_name := 'SEZER';\r\n  K1.email := 'yusufsezer@mail.com';\r\n  K1.phone := '+905386934533';\r\n  DBMS_OUTPUT.put_line(K1.first_name || ' ' || K1.last_name || ' - ' || K1.email || ' - ' || K1.phone);\r\nEND;<\/pre>\n<p>Record data types previously defined in the user-defined record can also be used. Another important feature of the Record data type is that it can pass parameters to structures that take parameters such as procedure and function. In this way, related parameters can be grouped and processed with a single record.<\/p>\n<p>You can find more detailed information about below topics in the below link.<\/p>\n<p><strong><a href=\"https:\/\/dbtut.com\/index.php\/2020\/03\/19\/pl-sql-tutorial\/\" target=\"_blank\" rel=\"noopener noreferrer\">PL\/SQL Tutorial<\/a><\/strong><\/p>\n<p>You will find below topics in this article.<\/p>\n<ol>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>What is PL\/SQL<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-data-types-and-variables-and-literals\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Data Types and Variables and Literals<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-operators\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Operators<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-conditional-statements\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Conditional Statements<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-loops\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Loops<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Procedures and Procedure Parameters<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-functions\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Functions<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-cursor\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Cursor<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Records<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-exception\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Exception<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-trigger\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Trigger<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-packages\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Packages<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-collections\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle PL\/SQL Collections<\/strong><\/a><\/li>\n<\/ol>\n<p>You can find more information about records at <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28370\/collections.htm#LNPLS005\" target=\"_blank\" rel=\"noopener noreferrer\">docs.oracle.com<\/a><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_17157\" class=\"pvc_stats all  \" data-element-id=\"17157\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records. What is Record in Oracle? Data types such as NUMBER, VARCHAR, VARCHAR2 in Oracle PL \/ SQL are used to store a single data. However, defining multiple variables related to each other makes the codes complicated. Record &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_17157\" class=\"pvc_stats all  \" data-element-id=\"17157\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":485,"featured_media":17158,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[10086,10085,9285,10087,9291,10084],"class_list":["post-17157","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-cursor-based-records-in-oracle-pl-sql","tag-table-based-records-in-oracle-pl-sql","tag-table-based-records-in-pl-sql","tag-user-defined-records-in-oracle-pl-sql","tag-user-defined-records-in-pl-sql","tag-what-is-record-in-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":197,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle PL\/SQL Records - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle PL\/SQL Records - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-11T12:27:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-11T15:28:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"516\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yusuf SEZER\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf SEZER\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"Oracle PL\/SQL Records\",\"datePublished\":\"2020-10-11T12:27:01+00:00\",\"dateModified\":\"2020-10-11T15:28:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\"},\"wordCount\":385,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg\",\"keywords\":[\"Cursor Based Records in Oracle PL\/SQL\",\"Table Based Records in Oracle PL\/SQL\",\"table based records in pl\/sql\",\"User Defined Records in Oracle PL\/SQL\",\"User Defined Records in PL\/SQL\",\"What is Record in Oracle?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\",\"name\":\"Oracle PL\/SQL Records - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg\",\"datePublished\":\"2020-10-11T12:27:01+00:00\",\"dateModified\":\"2020-10-11T15:28:38+00:00\",\"description\":\"This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg\",\"width\":750,\"height\":516},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle PL\/SQL Records\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\",\"name\":\"Yusuf SEZER\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"caption\":\"Yusuf SEZER\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle PL\/SQL Records - Database Tutorials","description":"This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.","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:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/","og_locale":"en_US","og_type":"article","og_title":"Oracle PL\/SQL Records - Database Tutorials","og_description":"This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/","og_site_name":"Database Tutorials","article_published_time":"2020-10-11T12:27:01+00:00","article_modified_time":"2020-10-11T15:28:38+00:00","og_image":[{"width":750,"height":516,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg","type":"image\/jpeg"}],"author":"Yusuf SEZER","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf SEZER","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"Oracle PL\/SQL Records","datePublished":"2020-10-11T12:27:01+00:00","dateModified":"2020-10-11T15:28:38+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/"},"wordCount":385,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg","keywords":["Cursor Based Records in Oracle PL\/SQL","Table Based Records in Oracle PL\/SQL","table based records in pl\/sql","User Defined Records in Oracle PL\/SQL","User Defined Records in PL\/SQL","What is Record in Oracle?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/","url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/","name":"Oracle PL\/SQL Records - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg","datePublished":"2020-10-11T12:27:01+00:00","dateModified":"2020-10-11T15:28:38+00:00","description":"This article contains information about Oracle PL\/SQL Records such as Table Based, Cursor Based and User Defined Records.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlrecords.jpg","width":750,"height":516},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-records\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle PL\/SQL Records"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a","name":"Yusuf SEZER","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","caption":"Yusuf SEZER"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/485"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=17157"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17157\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/17158"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=17157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=17157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=17157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}