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. Archives
May 2023
Categories |