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
Paessler - Monitor Your Whole Network in Minutes Icon
Paessler - Monitor Your Whole Network in Minutes

Auto-discovery finds your devices and deploys pre-configured sensors instantly. No project plan required, just visibility from day one.

Waiting weeks for a monitoring rollout isn't an option when infrastructure doesn't stop running. PRTG's auto-discovery scans your network and suggests from over 200 pre-configured sensor types, so you're watching servers, applications and devices within minutes, not after a multi-week deployment. Enterprise-strength monitoring, without the enterprise complexity. Start your free trial today.
Start Free 30-Day Trial
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
★
2
0
0
0
0
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

  • 5 out of 5 stars
    simple a utilisé merci pour ce script
  • 5 out of 5 stars
    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.
Read more reviews >

Additional Project Details

Intended Audience

Developers

Programming Language

PL/SQL

Database Environment

Oracle

Registered

2015-10-24