LOB2Table
Query CSV data in Oracle CLOBs, BLOBs, BFILEs or VARCHAR2s as tables
LOB2Table is a set of Oracle PL/SQL pipelined functions that allow you to query CSV or fixed column data store in CLOBs, BLOBs, BFILEs or VARCHAR2s like ordinary tables.
Please see the Wiki for a detailed description.