{"id":18066,"date":"2020-12-30T09:31:50","date_gmt":"2020-12-30T09:31:50","guid":{"rendered":"https:\/\/dbtut.com\/?p=18066"},"modified":"2020-12-30T09:35:00","modified_gmt":"2020-12-30T09:35:00","slug":"oracle-data-redaction-19c-examples","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/","title":{"rendered":"Oracle Data Redaction 19c Examples"},"content":{"rendered":"<p>This article contain information about Oracle Data Redaction in 19c Example. If you wonder about What is Oracle Data Redaction and methods, you may want to read the below article.<\/p>\n<p><a href=\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/what-is-oracle-data-redaction\/\" target=\"_blank\" rel=\"noopener\">What is Oracle Data Redaction<\/a><\/p>\n<p><strong>Important Note:<\/strong> Oracle Data Redaction comes with separate licensing (Oracle Advanced Security). You should not use this feature without license.<\/p>\n<p>I will perform this example with the HR scheme, which is one of the sample schemes. You can work on a table on a different scheme or create the HR user as follows.<\/p>\n<ol>\n<li>Set a password for the HR user.<\/li>\n<li>Set tablespace for HR user, if you pass it blank it gets default tablespace.<\/li>\n<li>Set temp tablespace for HR user, if you pass it blank, it gets default temp tablespace.<\/li>\n<li>Go blank.<\/li>\n<li>Set the Log location for the HR user, if you pass it blank, it gets the default location.<\/li>\n<\/ol>\n<pre class=\"lang:default decode:true \">$ sqlplus \/ as sysdba\r\nSQL&gt; @?\/demo\/schema\/human_resources\/hr_main.sql\r\n \r\nspecify password for HR as parameter 1:\r\nEnter value for 1:\r\n \r\nspecify default tablespace for HR as parameter 2:\r\nEnter value for 2:\r\n \r\nspecify temporary tablespace for HR as parameter 3:\r\nEnter value for 3:\r\n \r\nspecify password for SYS as parameter 4:\r\nEnter value for 4:\r\n \r\nspecify log path as parameter 5:\r\nEnter value for 5:\r\n \r\n \r\nPL\/SQL procedure successfully completed.\r\n \r\nUser created.\r\n \r\n.\r\n.\r\n.\r\n.\r\n.\r\n.\r\nPL\/SQL procedure successfully completed.<\/pre>\n<p>Now that our user has been created, we can start practicing. I will do my work on the EMPLOYEES table in HR user. This table stores personnel information and especially salary field.<\/p>\n<p>Let&#8217;s Select the whole table with a classic query.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"nLdLngU\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18068 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5feaeea3b24a3.png\" alt=\"\" width=\"874\" height=\"197\" \/><\/p>\n<p>We will perform the operations in the order I explained at the beginning of the article.<\/p>\n<h3>Full Oracle Data Redaction Example<\/h3>\n<p>First, we start with Full Redaction. First of all, I will do it for the SALARY field. When the code block below runs, the HR user will see this field as it should, while other users will see it as &#8220;0&#8221;.<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_REDACT.add_policy (object_schema   =&gt; 'HR',\r\n                            object_name     =&gt; 'EMPLOYEES',\r\n                            column_name     =&gt; 'SALARY',\r\n                            policy_name     =&gt; 'SALARY_KOLONO_ICIN_REDACTION',\r\n                            function_type   =&gt; DBMS_REDACT.full,\r\n                            expression      =&gt; '1=1');\r\nEND;\r\n\/<\/pre>\n<p>I select the table with my HR user. As you can see in the screenshot, everything is fine.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"IQKGDws\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18095 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec3246a8fb9.png\" alt=\"\" width=\"894\" height=\"183\" \/><\/p>\n<p>Now I&#8217;m running the same query with a different user. Other users see it as &#8220;0&#8221; as it is stuck in the Data Redaction process.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"ULzRqYV\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18096 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec32b742047.png\" alt=\"\" width=\"914\" height=\"190\" \/><\/p>\n<p>As we explained in the first part, there is a piece of information that I would like to remind.<\/p>\n<ul>\n<li>The default value of Full Redaction is &#8220;0&#8221;. If the data type in the column appears as NUMBER, it is replaced with &#8220;0&#8221;, if the data type is a character, it is replaced with a space.<\/li>\n<li>Users with SYSDBA and DBA privileges are not affected by these rules.<\/li>\n<\/ul>\n<p>So what if we run same code block for FIRST_NAME?<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_REDACT.alter_policy (object_schema   =&gt; 'HR',\r\n                            object_name     =&gt; 'HR.EMPLOYEES',\r\n                            column_name     =&gt; 'FIRST_NAME',\r\n                            policy_name     =&gt; 'SALARY_KOLONO_ICIN_REDACTION',\r\n                            function_type   =&gt; DBMS_REDACT.full,\r\n                            expression      =&gt; '1=1');\r\nEND;\r\n\/<\/pre>\n<p>As you can see, SALARY field with NUMBER value returned as &#8220;0&#8221;, while VARHCAR &#8220;FIRST_NAME&#8221; field returned as blank.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"dTAFJUw\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18097 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec33e2d59d8.png\" alt=\"\" width=\"848\" height=\"178\" \/><\/p>\n<h3>Partial Oracle Data Redaction Example<\/h3>\n<p>Another model is Partial. With this redaction, we can print digit from left to right. For example, let&#8217;s make the first three digits of a 6-digit salary &#8220;1&#8221;<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_REDACT.alter_policy (object_schema         =&gt; 'HR',\r\n                              object_name           =&gt; 'EMPLOYEES',\r\n                              policy_name           =&gt; 'SALARY_KOLONO_ICIN_REDACTION',\r\n                              action                =&gt; DBMS_REDACT.modify_column,\r\n                              column_name           =&gt; 'SALARY',\r\n                              function_type         =&gt; DBMS_REDACT.partial,\r\n                              function_parameters   =&gt; '1,1,3');\r\nEND;\r\n\/<\/pre>\n<p>Everything is normal with our HR user. Let&#8217;s try it with a different user.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"oVtoPTc\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18099 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec34ced15c7.png\" alt=\"\" width=\"877\" height=\"184\" \/><\/p>\n<p>As can be seen, other users see the first three digits as &#8220;1&#8221; and the remaining digits as normal.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"FFGtrKD\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18100 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec351b7ca09.png\" alt=\"\" width=\"876\" height=\"182\" \/><\/p>\n<h3>Random Oracle Data Redaction Example<\/h3>\n<p>Let&#8217;s take a look at the Random Redaction feature. This time we will make a change and work in the PHONE_NUMBER field. Our sample code block is as follows.<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_REDACT.alter_policy (object_schema   =&gt; 'HR',\r\n                              object_name     =&gt; 'EMPLOYEES',\r\n                              policy_name     =&gt; 'SALARY_KOLONO_ICIN_REDACTION',\r\n                              action          =&gt; DBMS_REDACT.add_column,\r\n                              column_name     =&gt; 'PHONE_NUMBER',\r\n                              function_type   =&gt; DBMS_REDACT.RANDOM);\r\nEND;\r\n\/<\/pre>\n<p>I am looking with my HR user. Everything is normal.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"UuDNoFb\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18101 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec35b030d35.png\" alt=\"\" width=\"857\" height=\"178\" \/><\/p>\n<p>I&#8217;m running the same query again with a different user. As you can see, PHONE_NUMBER field returned as random character.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT * FROM HR.EMPLOYEES<\/pre>\n<p id=\"SqbuGds\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18102 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/img_5fec35f562999.png\" alt=\"\" width=\"912\" height=\"184\" \/><\/p>\n<p>As you can see, it is very simple and most importantly, it is a feature that does not bring additional load for our database.<\/p>\n<p>Hope to see you in other articles,<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_18066\" class=\"pvc_stats all  \" data-element-id=\"18066\" 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 contain information about Oracle Data Redaction in 19c Example. If you wonder about What is Oracle Data Redaction and methods, you may want to read the below article. What is Oracle Data Redaction Important Note: Oracle Data Redaction comes with separate licensing (Oracle Advanced Security). You should not use this feature without license. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_18066\" class=\"pvc_stats all  \" data-element-id=\"18066\" 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":574,"featured_media":18104,"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":[10324,10331,10330,10323,10325,10329,10328,10327,10326],"class_list":["post-18066","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-data-redaction-examples","tag-full-data-redaction-example","tag-full-oracle-data-redaction-example","tag-oracle-data-redaction-19c-example","tag-oracle-data-redaction-examples","tag-partial-data-redaction-example","tag-partial-oracle-data-redaction-example","tag-random-data-redaction-example","tag-random-oracle-data-redaction-example"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Data Redaction 19c Examples - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains example about Oracle Data Redaction such as Full Data Redaction, Partial Data Redaction, Random Data Redaction.\" \/>\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\/12\/30\/oracle-data-redaction-19c-examples\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Data Redaction 19c Examples - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains example about Oracle Data Redaction such as Full Data Redaction, Partial Data Redaction, Random Data Redaction.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-30T09:31:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-30T09:35:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"739\" \/>\n\t<meta property=\"og:image:height\" content=\"366\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\/12\/30\/oracle-data-redaction-19c-examples\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"Oracle Data Redaction 19c Examples\",\"datePublished\":\"2020-12-30T09:31:50+00:00\",\"dateModified\":\"2020-12-30T09:35:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/\"},\"wordCount\":551,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg\",\"keywords\":[\"data redaction examples\",\"Full Data Redaction Example\",\"Full Oracle Data Redaction Example\",\"Oracle Data Redaction 19c Example\",\"oracle data redaction examples\",\"Partial Data Redaction Example\",\"Partial Oracle Data Redaction Example\",\"Random Data Redaction Example\",\"Random Oracle Data Redaction Example\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/\",\"name\":\"Oracle Data Redaction 19c Examples - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg\",\"datePublished\":\"2020-12-30T09:31:50+00:00\",\"dateModified\":\"2020-12-30T09:35:00+00:00\",\"description\":\"This article contains example about Oracle Data Redaction such as Full Data Redaction, Partial Data Redaction, Random Data Redaction.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg\",\"width\":739,\"height\":366},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Data Redaction 19c Examples\"}]},{\"@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\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Data Redaction 19c Examples - Database Tutorials","description":"This article contains example about Oracle Data Redaction such as Full Data Redaction, Partial Data Redaction, Random Data Redaction.","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\/12\/30\/oracle-data-redaction-19c-examples\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Data Redaction 19c Examples - Database Tutorials","og_description":"This article contains example about Oracle Data Redaction such as Full Data Redaction, Partial Data Redaction, Random Data Redaction.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/","og_site_name":"Database Tutorials","article_published_time":"2020-12-30T09:31:50+00:00","article_modified_time":"2020-12-30T09:35:00+00:00","og_image":[{"width":739,"height":366,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg","type":"image\/jpeg"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"Oracle Data Redaction 19c Examples","datePublished":"2020-12-30T09:31:50+00:00","dateModified":"2020-12-30T09:35:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/"},"wordCount":551,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg","keywords":["data redaction examples","Full Data Redaction Example","Full Oracle Data Redaction Example","Oracle Data Redaction 19c Example","oracle data redaction examples","Partial Data Redaction Example","Partial Oracle Data Redaction Example","Random Data Redaction Example","Random Oracle Data Redaction Example"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/","url":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/","name":"Oracle Data Redaction 19c Examples - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg","datePublished":"2020-12-30T09:31:50+00:00","dateModified":"2020-12-30T09:35:00+00:00","description":"This article contains example about Oracle Data Redaction such as Full Data Redaction, Partial Data Redaction, Random Data Redaction.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/12\/dataredactionexamples.jpg","width":739,"height":366},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/12\/30\/oracle-data-redaction-19c-examples\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Data Redaction 19c Examples"}]},{"@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\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/18066","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\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=18066"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/18066\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/18104"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=18066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=18066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=18066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}