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