Unanswered: need help with executing sql files on oracle
does anyone know how to execute a whole sql file on an oracle db with java?
i know there are executeQuery() for Queries and executeUpdate() for DDLs but they are for a single SQL statement only.
a sql file contains dozens of commands like creating tables, triggers, constrains, packages, procedures, functions, etc. and INSERT, UPDATE, etc. commands and i want to execute it at once (like the oracle tool SQLPlus does).
thanks for any help.