ora-cmd - Oracle interactive and batch query command-line tool »
ora-cmd can run in interactive mode, like this:
ora-cmd> connect pan:withdata@192.168.0.102:1521/test
db connected
ora-cmd> load table=media_messages
> datafile=f:\media_messages.txt
> delimiter=,
> quote="
> header=y;
In batch mode:
ora-cmd dsn="pan:withdata@192.168.0.102:1521/test" task=load table=media_messages datafile=f:\media_messages.txt delimiter=, quote=" header=y quit=y