how to read a BLOB in Oracle et break this Blob into different columns
Hello, I need to read an Oracle table that contains a BLOB column. This column will contains comma separated values. I need to load this BLOB column into different columns in another Oracle table. The data in this BLOB (or CLOB) may look like this : 2012-05-08;john;doe;canada;123;street name;city;province;
In fact, I want to take the value "2012-05-08" and store it in a column, take the value "john" and store it in another column, take the value "doe" and store it in another column, etc... I've searched the Internet for examples but I haven't found anything helpfull. The source column could also be a CLOB. How can I make Talend separate the BLOB/CLOB column in multiple varchar columns ? THank you Pascal Beaudoin
