6.2. PL/SQL

PL/SQL (and for PostgreSQL, PL/pgSQL) can be used to directly import data into the database. This approach has the advantage of being very fast, since it bypasses all Java code. However, it is difficult to maintain between data model changes, and care must be exercised to preserve data integrity, since it is not possible to model all domain constraints in the database. Nonetheless, for initial imports of large amounts of data, using PL/SQL can be the right choice.

Oracle Database includes a bulk loader called SQL*Loader that is expressly designed to import large amounts of data very rapidly. SQL*Loader can be configured to modify data as it is loaded into the database.