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.
Features
- Pure PL/SQL solution for Oracle Database 10g Release 1 and up in any edition
- Support for separated columns format (i.e. CSV)
- Support for fixed columns width formats
- Full delimiter support
- Up to 200 columns possible
- High performance (up to 15,000 rows per second)
- Automatic BOM removal
License
GNU Library or Lesser General Public License version 3.0 (LGPLv3)Follow LOB2Table
You Might Also Like
Rate This Project
Login To Rate This Project
User Reviews
-
simple a utilisé merci pour ce script
-
Looking for an effective way to load Excel Files (CSV) into Oracle (APEX) tables ? This is the perfect solution. Perhaps you seek a more performant or easier to implement solution to h t t p : / / avdeo.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/ "Uploading excel sheet using Oracle Application Express (APEX)" LOB2Table really performs well and I have had lots of success with it. The task of loading a CSV to a Oracle table has effectively been reduced to: 1) use the file upload feature within APEX to load the CSV to a LOB 2) use the LOB2Table function of this project to insert into table (col...) select LOB2Table on your LOB. (i.e. insert into table (col...) select LOB2Table...) As far as performance, I'm able to on a daily basis upload 35K rows of 30 columns across two tables, validate the headers and generate summary validation queries in less than 1 minute. This is significantly faster than even the native Data Loader and for daily uploads you can automate validation, conversions, mappings.... Highly recommend !!