{"id":5933,"date":"2026-01-19T07:00:00","date_gmt":"2026-01-19T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=5933"},"modified":"2026-01-18T19:42:16","modified_gmt":"2026-01-18T16:42:16","slug":"pos-metaferoyme-clob-pedia-keimenoy-oracle-dat","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-metapheroyme-clob-pedia-keimenoy-oracle-dat\/","title":{"rendered":"How to transfer CLOB text fields from Oracle Database to SQL Server without problems"},"content":{"rendered":"<p>If at some point we transfer many records with fields <strong>CLOB<\/strong> (large text) from Oracle Database to SQL Server with a database link that uses odbc driver there is a high probability of transferring the data incorrectly. More specifically we will see that the CLOB fields do not match the correct row they belong to but are mixed up between the records. In this article we will see a solution that solves the problem.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The solution<\/h2>\n\n\n\n<p>The solution to bypass this problem is to break the CLOB field when creating and transferring the table to SQL Server. <span style=\"text-decoration: underline;\">in many VARCHAR fields of 4,000 characters<\/span> depending on the maximum number of characters the field has. In the next step, let&#039;s add a field of type <strong>VARCHAR(MAX)<\/strong> which can hold up to 65,535 characters with the final name we want to bring the CLOB field. Finally, <span style=\"text-decoration: underline;\">we update the new field by joining all the VARCHAR2 fields that we separated at the beginning<\/span>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"> The code<\/h2>\n\n\n\n<p>With the following code we transfer the table by splitting the CLOB field into VARCHAR fields of 4,000 characters each:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select * into DBNAME.SCHEMA1.CUSTOMERS from openquery (LNKNAME,'select \nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,1) as VARCHAR2(4000)) as DATA_CLOB,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,4001) as VARCHAR2(4000)) as DATA_CLOB1,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,8001) as VARCHAR2(4000)) as DATA_CLOB2,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,12001) as VARCHAR2(4000)) as DATA_CLOB3,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,16001) as VARCHAR2(4000)) as DATA_CLOB4,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,20001) as VARCHAR2(4000)) as DATA_CLOB5,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,24001) as VARCHAR2(4000)) as DATA_CLOB6,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,28001) as VARCHAR2(4000)) as DATA_CLOB7,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,32001) as VARCHAR2(4000)) as DATA_CLOB8,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,36001) as VARCHAR2(4000)) as DATA_CLOB9,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,40001) as VARCHAR2(4000)) as DATA_CLOB10,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,44001) as VARCHAR2(4000)) as DATA_CLOB11,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,48001) as VARCHAR2(4000)) as DATA_CLOB12,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,52001) as VARCHAR2(4000)) as DATA_CLOB13,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,56001) as VARCHAR2(4000)) as DATA_CLOB14,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,60001) as VARCHAR2(4000)) as DATA_CLOB15,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,64001) as VARCHAR2(4000)) as DATA_CLOB16,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,68001) as VARCHAR2(4000)) as DATA_CLOB17,\nCAST(DBMS_LOB.SUBSTR(TEXT, 4000,72001) as VARCHAR2(4000)) as DATA_CLOB18,\n, ID, CUSTOMER from SCHEMA1.CUSTOMERS where 1=1');<\/pre>\n\n\n\n<p>With the following code we create in the table we transferred the CLOB field with the name it had as <strong>VARCHAR(MAX)<\/strong>:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">alter table DBNAME.SCHEMA1.CUSTOMERS add TEXT varchar(max);<\/pre>\n\n\n\n<p>Finally, with the following code, we update the VARCHAR(MAX) field by joining the VARCHAR fields that we broke during the transfer:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">UPDATE DBNAME.SCHEMA1.CUSTOMERS\nSET TEXT = \n \u00a0ISNULL(CAST(DATA_CLOB AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB1 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB2 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB3 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB4 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB5 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB6 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB7 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB8 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB9 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB10 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB11 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB12 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB13 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB14 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB15 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB16 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB17 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB18 AS VARCHAR(MAX)), '') +\n \u00a0 \u00a0ISNULL(CAST(DATA_CLOB19 AS VARCHAR(MAX)), '');<\/pre>\n\n\n\n<p>Of course now if we want we can delete the columns we created for the temporary fragmentation of the CLOB field.<\/p>","protected":false},"excerpt":{"rendered":"<p>If at some point we transfer many records with CLOB (large text) fields from Oracle Database to SQL Server with a database link that uses an odbc driver, there is a high probability that we will transfer the data incorrectly. More specifically, we will see that the CLOB fields do not match the correct row they belong to but are [\u2026]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"[]"},"categories":[11,15,16],"tags":[496,143,29,160,23,5,30],"class_list":["post-5933","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","category-oracle-db","tag-clob","tag-database-links","tag-databases","tag-linked-server","tag-microsoft","tag-oracle-database","tag-rdbms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/pos-metapheroyme-clob-pedia-keimenoy-oracle-dat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u0391\u03bd \u03c4\u03cd\u03c7\u03b5\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03b1 \u03c3\u03c4\u03b9\u03b3\u03bc\u03ae \u03ba\u03b1\u03b9 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 \u03c0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2 \u03bc\u03b5 \u03c0\u03b5\u03b4\u03af\u03b1 CLOB (\u03bc\u03b5\u03b3\u03ac\u03bb\u03bf\u03c5 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5) \u03b1\u03c0\u03cc Oracle Database \u03c0\u03c1\u03bf\u03c2 SQL Server \u03bc\u03b5 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf database link \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03b5\u03b9 \u03c7\u03c1\u03ae\u03c3\u03b7 odbc driver \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03bc\u03b5\u03b3\u03ac\u03bb\u03b7 \u03c0\u03b9\u03b8\u03b1\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03bb\u03ac\u03b8\u03bf\u03c2. \u03a0\u03b9\u03bf \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b1 \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b1 \u03c0\u03b5\u03b4\u03af\u03b1 CLOB \u03bd\u03b1 \u03bc\u03b7\u03bd \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03bc\u03b5 \u03c4\u03b7\u03bd \u03c3\u03c9\u03c3\u03c4\u03ae \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae \u03c0\u03bf\u03c5 \u03b1\u03bd\u03ae\u03ba\u03bf\u03c5\u03bd \u03b1\u03bb\u03bb\u03ac \u03bd\u03b1 \u03b5\u03b9\u03bd\u03b1\u03b9 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-metapheroyme-clob-pedia-keimenoy-oracle-dat\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-19T04:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1\",\"datePublished\":\"2026-01-19T04:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/\"},\"wordCount\":33,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"CLOB\",\"Database Links\",\"Databases\",\"Linked Server\",\"Microsoft\",\"Oracle Database\",\"RDBMS\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\",\"Oracle Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2026-01-19T04:00:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 - DataPlatform.gr","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:\/\/www.dataplatform.gr\/en\/pos-metapheroyme-clob-pedia-keimenoy-oracle-dat\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 - DataPlatform.gr","og_description":"\u0391\u03bd \u03c4\u03cd\u03c7\u03b5\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03b1 \u03c3\u03c4\u03b9\u03b3\u03bc\u03ae \u03ba\u03b1\u03b9 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 \u03c0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2 \u03bc\u03b5 \u03c0\u03b5\u03b4\u03af\u03b1 CLOB (\u03bc\u03b5\u03b3\u03ac\u03bb\u03bf\u03c5 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5) \u03b1\u03c0\u03cc Oracle Database \u03c0\u03c1\u03bf\u03c2 SQL Server \u03bc\u03b5 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf database link \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03b5\u03b9 \u03c7\u03c1\u03ae\u03c3\u03b7 odbc driver \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03bc\u03b5\u03b3\u03ac\u03bb\u03b7 \u03c0\u03b9\u03b8\u03b1\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03bb\u03ac\u03b8\u03bf\u03c2. \u03a0\u03b9\u03bf \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b1 \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b1 \u03c0\u03b5\u03b4\u03af\u03b1 CLOB \u03bd\u03b1 \u03bc\u03b7\u03bd \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03bc\u03b5 \u03c4\u03b7\u03bd \u03c3\u03c9\u03c3\u03c4\u03ae \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae \u03c0\u03bf\u03c5 \u03b1\u03bd\u03ae\u03ba\u03bf\u03c5\u03bd \u03b1\u03bb\u03bb\u03ac \u03bd\u03b1 \u03b5\u03b9\u03bd\u03b1\u03b9 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-metapheroyme-clob-pedia-keimenoy-oracle-dat\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2026-01-19T04:00:00+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1","datePublished":"2026-01-19T04:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/"},"wordCount":33,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["CLOB","Database Links","Databases","Linked Server","Microsoft","Oracle Database","RDBMS"],"articleSection":["Databases","Microsoft SQL Server","Oracle Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/","url":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/","name":"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2026-01-19T04:00:00+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-metaferoyme-clob-pedia-keimenoy-oracle-dat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5 CLOB \u03c0\u03b5\u03b4\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03b1\u03c0\u03cc Oracle Database \u03c3\u03b5 SQL Server \u03c7\u03c9\u03c1\u03af\u03c2 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/5933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=5933"}],"version-history":[{"count":4,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/5933\/revisions"}],"predecessor-version":[{"id":5937,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/5933\/revisions\/5937"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=5933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=5933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=5933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}