For example if you are trying to insert, instead of No not no hot to manipulate clob column with pl. This is not something with which people are going to meet favorably.
Also, as the data volume grows XMLAGG will eventually hit ORA-31186: Document contains too many nodes and, if you happen to have any strings of 4000 characters the XMLAGG method will fail with ORA-01489: result of string concatenation is too long Using COLLECT, these errors don't occur.
You can work directly with JSON data contained in file-system files by creating an external table that exposes it to the database.
For better performance, you can load the external-table data into an ordinary table.
',') from mytable b where a.column= b.column ) I have 1.2 million rows. Any suggestions, comments, direction would be appreciated.
This is a one-time load for now and incrementals after this first load but I would like to get it as fast as possible.
It lets you create and store collections of documents of any kind (not just JSON), retrieve them, and query them, without needing to know how the documents are stored in the database.