Slide
‹#› of 37
Complex Case
uThe problem:
ØUsers upload CSV-files
§Name of file defines type
§Column headers map directly to table columns.
§One row of file could mean multiple inserts
uWrong solution
ØParse file in the middle-tier and build inserts.
uRight solution:
ØLoad file to the database as CLOB.
ØBuild all inserts in the database.
