Hi, all,
I'm using oracle 12c, and i should want to know what is the best way of reading a clob, line by line and split the line to insert it in a table:
Try to explain better:
I have a clob like this:
KEY;;;DETINARY;;;ADDRESS;;;CAP;;;CITY;;;REFERENCE;;;VAL
1;;;rossi gialloi;;;Via Nino Oxia, 6;;;50124;;;firenze;;;Prova 1;;;shshs ydydyd yfyfyf
1;;;rossi verde;;;Via Nino Oxia, 6;;;50124;;;firenze;;;Prova 1;;;shshs ydydyd yfyfyf
1;;;rossi rosso;;;Via Nino Oxia, 6;;;50124;;;firenze;;;Prova 1;;;shshs ydydyd yfyfyf
i need to read every line and insert every field (separated by ;;;) in a field of a table;
The clob can contains many row.
thanks