{"id":25038,"date":"2024-03-16T04:15:23","date_gmt":"2024-03-16T04:15:23","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/"},"modified":"2024-03-22T05:12:25","modified_gmt":"2024-03-22T05:12:25","slug":"how-to-import-a-csv-file-using-pl-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/","title":{"rendered":"How to import a CSV file using PL\/SQL?"},"content":{"rendered":"

In PL\/SQL, external tables can be used to import CSV files. These external tables serve as a virtual representation of the data, as they act as pointers to the CSV files rather than containing the data itself.<\/p>\n

Here is an example of importing a CSV file using an external table:<\/p>\n

    \n
  1. Set up a directory to store CSV files. For example:<\/li>\n<\/ol>\n
    CREATE<\/span> DIRECTORY csv_dir AS<\/span> '\/path\/to\/csv\/files'<\/span>;\r\n<\/code><\/pre>\n
      \n
    1. Create an external table pointing to a CSV file, for example:<\/li>\n<\/ol>\n
      CREATE<\/span> TABLE<\/span> csv_data\r\n(\r\n  column1 VARCHAR2(100<\/span>),\r\n  column2 NUMBER,\r\n  column3 DATE<\/span>\r\n)\r\nORGANIZATION EXTERNAL<\/span>\r\n(\r\n  TYPE ORACLE_LOADER\r\n  DEFAULT<\/span> DIRECTORY csv_dir\r\n  ACCESS PARAMETERS\r\n  (\r\n    RECORDS DELIMITED BY<\/span> NEWLINE\r\n    FIELDS TERMINATED BY<\/span> ','<\/span>\r\n    MISSING FIELD VALUES<\/span> ARE<\/span> NULL<\/span>\r\n  )\r\n  LOCATION ('data.csv'<\/span>)\r\n)\r\nREJECT LIMIT UNLIMITED;\r\n<\/code><\/pre>\n
      In the above example, csv_data is the name of the external table, and column1, column2, and column3 are the column names in the CSV file. Each row in the CSV file will be parsed as a record in the external table.<\/p>\n
        \n
      1. Query data from an external table using the SELECT statement. For example:<\/li>\n<\/ol>\n
        SELECT<\/span> *<\/span> FROM<\/span> csv_data;\r\n<\/code><\/pre>\n
        Once the above steps are completed, you can access the data in the CSV file by querying the external table. It is important to note that the external table is just a virtual table and does not store actual data, but rather reads data by pointing to the CSV file.<\/p>\n","protected":false},"excerpt":{"rendered":"
        In PL\/SQL, external tables can be used to import CSV files. These external tables serve as a virtual representation of the data, as they act as pointers to the CSV files rather than containing the data itself. Here is an example of importing a CSV file using an external table: Set up a directory to […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-25038","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow to import a CSV file using PL\/SQL? - Blog - Silicon Cloud<\/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.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to import a CSV file using PL\/SQL?\" \/>\n<meta property=\"og:description\" content=\"In PL\/SQL, external tables can be used to import CSV files. These external tables serve as a virtual representation of the data, as they act as pointers to the CSV files rather than containing the data itself. Here is an example of importing a CSV file using an external table: Set up a directory to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T04:15:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T05:12:25+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How to import a CSV file using PL\/SQL?\",\"datePublished\":\"2024-03-16T04:15:23+00:00\",\"dateModified\":\"2024-03-22T05:12:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\"},\"wordCount\":185,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\",\"name\":\"How to import a CSV file using PL\/SQL? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T04:15:23+00:00\",\"dateModified\":\"2024-03-22T05:12:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to import a CSV file using PL\/SQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to import a CSV file using PL\/SQL? - Blog - Silicon Cloud","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.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/","og_locale":"en_US","og_type":"article","og_title":"How to import a CSV file using PL\/SQL?","og_description":"In PL\/SQL, external tables can be used to import CSV files. These external tables serve as a virtual representation of the data, as they act as pointers to the CSV files rather than containing the data itself. Here is an example of importing a CSV file using an external table: Set up a directory to […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T04:15:23+00:00","article_modified_time":"2024-03-22T05:12:25+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How to import a CSV file using PL\/SQL?","datePublished":"2024-03-16T04:15:23+00:00","dateModified":"2024-03-22T05:12:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/"},"wordCount":185,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/","name":"How to import a CSV file using PL\/SQL? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T04:15:23+00:00","dateModified":"2024-03-22T05:12:25+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-a-csv-file-using-pl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to import a CSV file using PL\/SQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=25038"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25038\/revisions"}],"predecessor-version":[{"id":59113,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25038\/revisions\/59113"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=25038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=25038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=25038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}