VoraX is a simple yet powerful IDE for Oracle databases that relies on the widely known SqlPLUS which is actually used to connect to the database, to execute SQL statements and to get the results back.
Nonetheless, this interaction is hidden from the user who just uses his/her Vim environment without knowing that, behind, a SqlPLUS process does all the work.
The big advantage of this approach is that almost all SqlPLUS commands may be used without a problem.
You will be able to format columns, set pagination, autotrace queries etc. Basically, everything you used to type on your SqlPLUS prompt is guaranteed to work in VoraX, except maybe for some exotic cases (e.g. using vim in console mode, having the EDITOR set to a terminal editor and executing the "ed" sqlplus command).
The other advantage is that you'll get an efficient Oracle IDE with a very small footprint. For Oracle DBAs this is huge because they don't need heavy tools with a lot of features they never use. Hence, the fact that VoraX may be used within a regular console makes it suitable for server environments.
VoraX is cross-platform and it works on Mac OS X, Windows and Linux.
Detailed instructions on how to install and use the VoraX utility on your Mac are available HERE.
Here are some key features of "VoraX":
· 99.9% of the sqlplus commands supported
· advanced code completion
· it runs on Unix, Windows and Mac OS
· a nice results window with highlighting for errors and logging support
· a database explorer which may be used to browse the database objects in a hierarchical way
· support for editing and compiling PLSQL objects like packages, types etc.
· convenient key mappings for: describe object under cursor, execute current statement etc.
· connection profiles management (including securely storing of passwords)
· fuzzy search for database items
· offline search for Oracle html documentation