{"id":952,"date":"2017-06-22T07:21:37","date_gmt":"2017-06-22T07:21:37","guid":{"rendered":"https:\/\/vinish.dev\/?p=952"},"modified":"2025-05-11T08:44:42","modified_gmt":"2025-05-11T03:14:42","slug":"split-large-textcsv-file-multiple-files-pl-sql","status":"publish","type":"post","link":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql","title":{"rendered":"Split Large Text\/CSV File into Multiple Files in PL SQL"},"content":{"rendered":"\n<p>Sometimes, you may encounter a situation where you have a very large text or <a href=\"https:\/\/vinish.dev\/import-csv-file-in-oracle-table-using-stored-procedure\">CSV file<\/a> that is cumbersome to open or process all at once. In such cases, it is often useful to split the large file into several smaller files. This not only makes processing faster and more manageable but also helps to avoid performance issues that can occur when handling large files.<\/p>\n\n\n\n<p>In this article, I will provide a practical example of how you can split a large text or CSV file into multiple smaller files using a PL\/SQL stored procedure.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"key-steps\">Key Steps to Split a Large File in PL\/SQL<\/h2>\n\n\n\n<p>The PL\/SQL procedure requires two input parameters:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Database Directory Object Name<\/strong>: The Oracle directory object where your text files are located.<\/li>\n\n\n\n<li><strong>Source File Name<\/strong>: The name of the file you want to split.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">Creating the Oracle Directory Object<\/h4>\n\n\n\n<p>Before you can use the procedure, ensure that there is an Oracle directory object pointing to the location of your text files. If it does not exist, you can create it as follows:<\/p>\n\n\n\n<p>For <strong>Windows<\/strong> systems:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">For windows:\nCREATE OR REPLACE DIRECTORY CSV_FILE_DIR AS 'D:\\plsql\\text_files';<\/pre>\n\n\n\n<p>For <strong>Linux\/Unix<\/strong> systems (note the difference in the file path format):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">For Linux\/Unix (due to difference in path):\nCREATE OR REPLACE DIRECTORY CSV_FILE_DIR AS '\/plsql\/text_files';<\/pre>\n\n\n\n<p>Make sure to replace the directory path with the actual location where your files are stored.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"stored-proc\">PL\/SQL Procedure to Split the File<\/h2>\n\n\n\n<p>Once your directory object is set up, you can create the following PL\/SQL procedure to handle the file splitting:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE OR REPLACE PROCEDURE split_file (p_db_dir IN VARCHAR2,\n p_file_name IN VARCHAR2)\nIS\n read_file UTL_FILE.file_type;\n write_file UTL_FILE.file_type;\n v_string VARCHAR2 (32767);\n j NUMBER := 1;\nBEGIN\n read_file := UTL_FILE.fopen (p_db_dir, p_file_name, 'r');\n\nWHILE j &gt; 0\n LOOP\n write_file := UTL_FILE.fopen (p_db_dir, j || '_' || p_file_name, 'w');\n\nFOR i IN 1 .. 100\n LOOP -- example to dividing into 100 rows for each file.. you can increase the number as per your requirement\n UTL_FILE.get_line (read_file, v_string);\n UTL_FILE.put_line (write_file, v_string);\n END LOOP;\n\nUTL_FILE.fclose (write_file);\n j := J + 1;\n END LOOP;\nEXCEPTION\n WHEN OTHERS\n THEN\n -- this will handle if reading source file contents finish\n UTL_FILE.fclose (read_file);\n UTL_FILE.fclose (write_file);\nEND;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-it-works\">How the Procedure Works<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The procedure reads the original file line by line.<\/li>\n\n\n\n<li>It writes a specified number of lines (in this example, 100) to each new file.<\/li>\n\n\n\n<li>Each smaller file is named with a prefix number followed by the original file name (e.g., <code>1_text_file.csv<\/code>, <code>2_text_file.csv<\/code>, etc.).<\/li>\n\n\n\n<li>Once the specified number of lines is written, the current output file is closed and a new file is started for the next set of lines.<\/li>\n\n\n\n<li>The process continues until the entire source file has been read and split.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Note:<\/strong><br>You can adjust the number <code>100<\/code> in the <code>FOR i IN 1 .. 100<\/code> loop to control how many lines each output file will contain. Increase or decrease this value as needed based on your requirements.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"exec-proc\">Executing the Procedure<\/h2>\n\n\n\n<p>To execute the procedure, simply call it with the appropriate directory object name and file name as parameters:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\n split_file ('CSV_FILE_DIR', 'text_file.csv');\nEND;<\/pre>\n\n\n\n<p>After running the procedure, check the directory specified by your Oracle directory object (<code>CSV_FILE_DIR<\/code>). You will find multiple files named in sequence, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>1_text_file.csv<\/code><\/li>\n\n\n\n<li><code>2_text_file.csv<\/code><\/li>\n\n\n\n<li><code>3_text_file.csv<\/code><\/li>\n\n\n\n<li>...and so on.<\/li>\n<\/ul>\n\n\n\n<p>Each of these files will contain up to 100 lines from the original file, making them much easier to work with.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p>Splitting large text or CSV files into smaller chunks can be extremely useful when processing or transferring large datasets. With this PL\/SQL procedure, you can automate the process directly within Oracle, ensuring efficient and reliable file management. Adjust the file chunk size and directory settings to suit your specific needs, and streamline your data workflows with ease.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"636\" height=\"344\" src=\"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png\" alt=\"split large text\/csv file into multiple files in pl sql\" class=\"wp-image-953\" srcset=\"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png 636w, https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext-300x162.png 300w, https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext-600x325.png 600w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes, you may encounter a situation where you have a very large text or CSV file that is cumbersome to open or process all at once. In such cases, it is often useful to split the large file into several smaller files. This not only makes processing faster and more manageable but also helps to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-952","post","type-post","status-publish","format-standard","hentry","category-plsql"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Split Large Text\/CSV File into Multiple Files in PL SQL &#8226; Vinish.Dev<\/title>\n<meta name=\"description\" content=\"Oracle stored procedure example to split large text\/csv file into multiple files in PL SQL, means it will split large file into smaller files using PL SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Split Large Text\/CSV File into Multiple Files in PL SQL &#8226; Vinish.Dev\" \/>\n<meta property=\"og:description\" content=\"Oracle stored procedure example to split large text\/csv file into multiple files in PL SQL, means it will split large file into smaller files using PL SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql\" \/>\n<meta property=\"og:site_name\" content=\"Vinish.Dev\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/foxinfotech2014\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-22T07:21:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-11T03:14:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png\" \/>\n\t<meta property=\"og:image:width\" content=\"636\" \/>\n\t<meta property=\"og:image:height\" content=\"344\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vinish Kapoor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/x.com\/vinish_kapoor\" \/>\n<meta name=\"twitter:site\" content=\"@foxinfotech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinish Kapoor\" \/>\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:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql\"},\"author\":{\"name\":\"Vinish Kapoor\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/#\\\/schema\\\/person\\\/a7790479716d2a54131ca873f8483d3f\"},\"headline\":\"Split Large Text\\\/CSV File into Multiple Files in PL SQL\",\"datePublished\":\"2017-06-22T07:21:37+00:00\",\"dateModified\":\"2025-05-11T03:14:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql\"},\"wordCount\":486,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/#\\\/schema\\\/person\\\/df5e5ca816f6f4302efc03cf58dc97b4\"},\"image\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/splittext.png\",\"articleSection\":[\"PLSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql\",\"url\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql\",\"name\":\"Split Large Text\\\/CSV File into Multiple Files in PL SQL &#8226; Vinish.Dev\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/splittext.png\",\"datePublished\":\"2017-06-22T07:21:37+00:00\",\"dateModified\":\"2025-05-11T03:14:42+00:00\",\"description\":\"Oracle stored procedure example to split large text\\\/csv file into multiple files in PL SQL, means it will split large file into smaller files using PL SQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage\",\"url\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/splittext.png\",\"contentUrl\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/splittext.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/split-large-textcsv-file-multiple-files-pl-sql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/vinish.dev\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PLSQL\",\"item\":\"https:\\\/\\\/vinish.dev\\\/category\\\/plsql\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Split Large Text\\\/CSV File into Multiple Files in PL SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/#website\",\"url\":\"https:\\\/\\\/vinish.dev\\\/\",\"name\":\"Vinish.Dev\",\"description\":\"Vinish Kapoor&#039;s Blog: Best Oracle Blog for Developers\",\"publisher\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/#\\\/schema\\\/person\\\/df5e5ca816f6f4302efc03cf58dc97b4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vinish.dev\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/vinish.dev\\\/#\\\/schema\\\/person\\\/df5e5ca816f6f4302efc03cf58dc97b4\",\"name\":\"Vinish Kapoor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/vinishprofile.png\",\"url\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/vinishprofile.png\",\"contentUrl\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/vinishprofile.png\",\"width\":192,\"height\":192,\"caption\":\"Vinish Kapoor\"},\"logo\":{\"@id\":\"https:\\\/\\\/vinish.dev\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/vinishprofile.png\"},\"description\":\"Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 25+ years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.\",\"sameAs\":[\"https:\\\/\\\/vinish.dev\\\/\",\"https:\\\/\\\/www.facebook.com\\\/foxinfotech2014\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/vinish-kapoor\\\/\",\"https:\\\/\\\/x.com\\\/foxinfotech\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/vinish.dev\\\/#\\\/schema\\\/person\\\/a7790479716d2a54131ca873f8483d3f\",\"name\":\"Vinish Kapoor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a67232caa79b11f24f16c371866a96cfb575e011ebda6fa6e3d088a837a31bde?s=96&d=identicon&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a67232caa79b11f24f16c371866a96cfb575e011ebda6fa6e3d088a837a31bde?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a67232caa79b11f24f16c371866a96cfb575e011ebda6fa6e3d088a837a31bde?s=96&d=identicon&r=g\",\"caption\":\"Vinish Kapoor\"},\"description\":\"Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 25+ years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.\",\"sameAs\":[\"https:\\\/\\\/vinish.dev\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/vinish-kapoor\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/x.com\\\/vinish_kapoor\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Split Large Text\/CSV File into Multiple Files in PL SQL &#8226; Vinish.Dev","description":"Oracle stored procedure example to split large text\/csv file into multiple files in PL SQL, means it will split large file into smaller files using PL SQL.","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:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql","og_locale":"en_US","og_type":"article","og_title":"Split Large Text\/CSV File into Multiple Files in PL SQL &#8226; Vinish.Dev","og_description":"Oracle stored procedure example to split large text\/csv file into multiple files in PL SQL, means it will split large file into smaller files using PL SQL.","og_url":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql","og_site_name":"Vinish.Dev","article_publisher":"https:\/\/www.facebook.com\/foxinfotech2014","article_published_time":"2017-06-22T07:21:37+00:00","article_modified_time":"2025-05-11T03:14:42+00:00","og_image":[{"width":636,"height":344,"url":"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png","type":"image\/png"}],"author":"Vinish Kapoor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/x.com\/vinish_kapoor","twitter_site":"@foxinfotech","twitter_misc":{"Written by":"Vinish Kapoor","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#article","isPartOf":{"@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql"},"author":{"name":"Vinish Kapoor","@id":"https:\/\/vinish.dev\/#\/schema\/person\/a7790479716d2a54131ca873f8483d3f"},"headline":"Split Large Text\/CSV File into Multiple Files in PL SQL","datePublished":"2017-06-22T07:21:37+00:00","dateModified":"2025-05-11T03:14:42+00:00","mainEntityOfPage":{"@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql"},"wordCount":486,"commentCount":8,"publisher":{"@id":"https:\/\/vinish.dev\/#\/schema\/person\/df5e5ca816f6f4302efc03cf58dc97b4"},"image":{"@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage"},"thumbnailUrl":"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png","articleSection":["PLSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql","url":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql","name":"Split Large Text\/CSV File into Multiple Files in PL SQL &#8226; Vinish.Dev","isPartOf":{"@id":"https:\/\/vinish.dev\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage"},"image":{"@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage"},"thumbnailUrl":"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png","datePublished":"2017-06-22T07:21:37+00:00","dateModified":"2025-05-11T03:14:42+00:00","description":"Oracle stored procedure example to split large text\/csv file into multiple files in PL SQL, means it will split large file into smaller files using PL SQL.","breadcrumb":{"@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#primaryimage","url":"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png","contentUrl":"https:\/\/vinish.dev\/wp-content\/uploads\/2017\/06\/splittext.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vinish.dev\/split-large-textcsv-file-multiple-files-pl-sql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vinish.dev\/"},{"@type":"ListItem","position":2,"name":"PLSQL","item":"https:\/\/vinish.dev\/category\/plsql"},{"@type":"ListItem","position":3,"name":"Split Large Text\/CSV File into Multiple Files in PL SQL"}]},{"@type":"WebSite","@id":"https:\/\/vinish.dev\/#website","url":"https:\/\/vinish.dev\/","name":"Vinish.Dev","description":"Vinish Kapoor&#039;s Blog: Best Oracle Blog for Developers","publisher":{"@id":"https:\/\/vinish.dev\/#\/schema\/person\/df5e5ca816f6f4302efc03cf58dc97b4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vinish.dev\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vinish.dev\/#\/schema\/person\/df5e5ca816f6f4302efc03cf58dc97b4","name":"Vinish Kapoor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vinish.dev\/wp-content\/uploads\/2023\/12\/vinishprofile.png","url":"https:\/\/vinish.dev\/wp-content\/uploads\/2023\/12\/vinishprofile.png","contentUrl":"https:\/\/vinish.dev\/wp-content\/uploads\/2023\/12\/vinishprofile.png","width":192,"height":192,"caption":"Vinish Kapoor"},"logo":{"@id":"https:\/\/vinish.dev\/wp-content\/uploads\/2023\/12\/vinishprofile.png"},"description":"Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 25+ years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.","sameAs":["https:\/\/vinish.dev\/","https:\/\/www.facebook.com\/foxinfotech2014","https:\/\/www.linkedin.com\/in\/vinish-kapoor\/","https:\/\/x.com\/foxinfotech"]},{"@type":"Person","@id":"https:\/\/vinish.dev\/#\/schema\/person\/a7790479716d2a54131ca873f8483d3f","name":"Vinish Kapoor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a67232caa79b11f24f16c371866a96cfb575e011ebda6fa6e3d088a837a31bde?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a67232caa79b11f24f16c371866a96cfb575e011ebda6fa6e3d088a837a31bde?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a67232caa79b11f24f16c371866a96cfb575e011ebda6fa6e3d088a837a31bde?s=96&d=identicon&r=g","caption":"Vinish Kapoor"},"description":"Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 25+ years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.","sameAs":["https:\/\/vinish.dev\/","https:\/\/www.linkedin.com\/in\/vinish-kapoor\/","https:\/\/x.com\/https:\/\/x.com\/vinish_kapoor"]}]}},"_links":{"self":[{"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/posts\/952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/comments?post=952"}],"version-history":[{"count":2,"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/posts\/952\/revisions"}],"predecessor-version":[{"id":19077,"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/posts\/952\/revisions\/19077"}],"wp:attachment":[{"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/media?parent=952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/categories?post=952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vinish.dev\/wp-json\/wp\/v2\/tags?post=952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}