created by

Alexandru Tica

script type

utility

description

VoraX aims to be a simple, yet a powerful IDE for Oracle databases. Instead of reinventing the wheel, VoraX relies on the well-known SqlPLUS which is actually used to connect to the database, to execute and to get the results back. However, 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, in VoraX, almost all SqlPLUS commands may be used without any problems. You can 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). Another 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. Likewise, the fact that VoraX may be used within a regular console makes it suitable for server environments. FEATURES     * 99.9% of the sqlplus commands supported     * advanced code completion system     * Windows and UNIX systems are supported     * 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. This project is hosted on: http://code.google.com/p/vorax/

install details

VoraX follows the standard procedure of installing a Vim plugin. However, you need to take care of some dependencies VoraX relies on:    1. your vim must have ruby support enabled. In order to check this you may execute :version and look for +ruby.    2. ruby 1.8 (1.8.7 is the recommended version)    3. rubygems (on Debian systems is as simple as: sudo apt-get install rubygems)    4. the antlr3 ruby gem. You may install it using: gem install antlr3 -r    5. for Windows OS, besides ruby, you'll also need the win32-api gem. You may install it using: gem install win32-api -r    6. a working Oracle client with sqlplus, which has to be available in the environment $PATH variable. The instant client with sqlplus should be just fine.    7. optionally, if you want to securely store passwords for your Oracle connections then the openssl ruby extension must be available. On Ubuntu/Debian systems you may use the following command to install it: sudo apt-get install libopenssl-ruby1.8 Please notice that only ruby 1.8 is supported for the moment therefore be careful not to install ruby 1.9 instead. Optionally, you may install the following plugins VoraX integrates with:     * NERDTree: http://www.vim.org/scripts/script.php?script_id=1658     * XpTemplate: http://www.vim.org/scripts/script.php?script_id=2611     * TagList: http://www.vim.org/scripts/script.php?script_id=273     * FuzzyFinder: http://www.vim.org/scripts/script.php?script_id=1984 After the installation is done it is advisable to index the documentation using the following commands:     * :helptags $VIM/.vim/doc (Unix)     * :helptags $VIM/vimfiles/doc (Windows)

Click on the package to download.

package	script version	date	Vim version	user	release notes
vorax-2.2.zip	2.2	2010-09-08	7.2	Alexandru Tica	* refresh output window     * cygwin interface support     * bug fix: E121: Undefined variable: s:last_line (reported by Pierre Raimbault)     * bug fix: some sqlplus keywords were partially highlighted     * bug fix: Completion list for parameters was not computed correctly for some procs/funcs     * bug fix: errors when output in a non-modifiable result buffer     * bug fix: fuzzy search pattern was not properly escaped (reported by Ingo Olbrich)
vorax-2.1.zip	2.1	2010-08-18	7.2	Alexandru Tica	* fuzzy search for database items (needs fuzzyfinder pluging)     * you can now describe an object directly from the DbExplorer (thanks to Shaun Batterton)     * updated syntax highlighting to reflect more closely the Oracle/sqlplus syntax     * added sqlplus keywords to keyword completion     * bug fix: DESC for fully qualified tables (reported by Shaun)     * bug fix: Empty DB explorer on the second display (reported by Spratek)     * bug fix: DB explorer does not work when EZCONNECT is used (reported by Spratek)     * bug fix: ORA-00904 in omni completion for package procedures in Oracle XE     * bug fix: the $ and # are not considered as word characters into plsql/sql buffers
vorax-2.0.zip	2.0	2010-08-05	7.0	Alexandru Tica	* the ability to store passwords for Oracle connection profiles (proposed by Shaun Batterton)     * verbose describe for tables and views. The verbose version contains: table/view comments, column comments, constraints, relationships etc. (proposed by Spratek)     * the option to automatically open a scratch sql buffer on the first connect (proposed by Shaun Batterton)     * the results windows is aware of the "Describe" and "Go To Definition" key bindings     * bug fix: omnifunc for packages may raise errors when invoked in unusual contexts (reported by Spratek)     * bug fix: toolkit libs loading problems     * bug fix: Packages under the +Users node doesn't have: Spec, Body, Both (reported by Shaun Batterton)     * bug fix: The config file with connection profiles should reside within the user's home folder. After upgrade move your /config/vorax_connections file into your home directory.
vorax-1.9.zip	1.9	2010-07-30	7.0	Alexandru Tica	* a window with connection profiles added (thanks spratek for this suggestion)     * bug fix: the sql delimitator was not added     * bug fix: The statement under cursor is not computed correctly when the end delimitator is within quotes.     * bug fix: Version 1.8 had the debug flag enabled.     * bug fix: Reconnect after cancel statement doesn't work correctly on Windows.     * bug fix: The windows interface does not shutdown correctly.
vorax-1.8.zip	1.8	2010-07-29	7.0	Alexandru Tica	* integration with taglist plugin     * go to definition feature     * bug fix: cannot connect using EZCONNECT     * bug fix: prompt for values don't work
vorax-1.7.zip	1.7	2010-07-26	7.0	Alexandru Tica	* logging support for the result window     * support for displaying the executed command. Just execute "set echo on" or add this to g:vorax_header variable     * bug fix: describe object under cursor does not work     * bug fix: Unix interface may not be initialized correctly.
vorax-1.6.zip	1.6	2010-07-23	7.0	Alexandru Tica	* code completion for keywords added (thanks Shaun Batterton for this suggestion)     * DbExplorer allows browsing database objects which belong to other users (thanks Shaun Batterton for this suggestion)     * new mappings defined for DbExplorer: "o" for opening a node (to be more closer to NERDTree way of navigating the tree) and "R" to refresh a node.     * add the possibility to describe a visual selected object     * bug fix: irrelevant items may be returned into completion list
vorax-1.5.zip	1.5	2010-07-21	7.0	Alexandru Tica	* a NERDTree plugin added in order to execute a sql script directly from the file browser; * packages, types, procedures, functions and trigger scripts are syntax highlighted as plsql instead of sql; * XpTemplate snippets for various sql/plsql blocks; * bug fix: the DbExplorer window might not be layed out at the same position after a toggle off/on. * bug fix: vorax#UnderCursorStatement not working correctly if filetype=plsql
vorax-1.4.zip	1.4	2010-07-19	7.0	Alexandru Tica	* code completion for function/procedure parameters * set buffer specific mappings to be active just within an sql buffer. * when it's not obvious, the db object type is also shown for every item within the completion list.
vorax-1.3.zip	1.3	2010-07-17	7.2	Alexandru Tica	Initial upload