LOB2Table

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

Project Activity

See All Activity >

License

GNU Library or Lesser General Public License version 3.0 (LGPLv3)

Follow LOB2Table

LOB2Table Web Site

Other Useful Business Software

Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.

Try free now

Rate This Project

User Ratings

5.0 out of 5 stars

★★★★★

★★★★

★★★

★★

★

ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5

features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5

design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5

support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

User Reviews

Filter Reviews:

All

lamjedba Posted 2022-08-12

simple a utilisé merci pour ce script
pungaret Posted 2016-01-06

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 !!

1 user found this review helpful.