OraCmd

OraCmd is a command-line piece of software that facilitates a speedy method to establish a direct connection to Oracle via the TCP/IP protocol without using the Oracle client. There's also a GUI edition available for those inexperienced with the console interface, called OraLoader.

To connect to the Oracle server, it's necessary to enter the host name, port and system identifier that specifies the Global Database Name, in addition to the user name and password. The key can be hidden.

Plain text documents, Excel, CSV and SQL files can be imported and exported to Oracle. You can view table structures and create database objects, such as table, view, procedure/function and type.

It's possible to schedule tasks to run at specific times by creating and running batch files with one click, display results in vertical form, as well as switch to interactive mode to run SQL scripts from files. LOB (BLOB, CLOB) data can be exported to file, while Oracle Stored Procedures can be called from OraCmd.

A wide range of examples can be studied at the developer's website, such as scheduling tasks, unloading data from queries or to stdout (not to file), or unloading the date format.