Simple csv file parser9/17/2023 The last part of this post will focus on the limitations. Parsing a simple CSV content, with no quoted field, is however possible with minimum effort using XMLTABLE or JSON_TABLE functions.īoth approaches are based on a little preprocessing to convert the data to the required format and pass it to the corresponding function. Mike Kutz submitted the idea a couple of years ago : parse CLOBS/BLOBS using “external table” capability. Oracle does not currently provide any built-in functionality to parse a flat file stored in the database as CLOB (or BLOB), like the External Table facility for external files.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |