Talend Open Studio can retrieve XML from an XMLType column in an Oracle table. The default handling for an XMLType column is to treat the data is an Object. A special setting on a tOracleInput will treat the XMLType as text, making it available for export to a text file.
Start with a job that connects a tOracleInput to a tFilterColumns.
|Job Exporting an XMLType to a File|
|Schema Referencing XMLType|
|Interpret the XMLType as a String|