In this post I want however to talk a little bit about the new features this version brings in. The most important one, in my opinion, is the fuzzy search feature. The idea came from a practical need. I don't know about you but, personally, I have troubles remembering various package names, tables, views etc. You may say: okey, but you can use code completion, right? Yes, of course, but what if you don't know how the object name starts? For example, let's say I want to query the AWR snapshots. Frankly, I don't know exactly where these snapshots resides, but I (fuzzy) remember that it's something with "snapshot". So, I am in the middle of:
SELECT * FROM |<-- cursor here in insert mode
Now, I can invoke vorax fuzzy search. While in insert mode type <Leader> vl (vl stands for vorax locate). A prompt will be shown at the top and you can type there: snapshot. Pay attention that the list with the candidate items will start to be populated after you type at least three characters. You should see in the list the view you are looking for:
DBA_HIST_SNAPSHOT. Oooh, yea I remember... that's it! Just select it, press ENTER and
DBA_HIST_SNAPSHOTwill be inserted at the current cursor position. Nice!
Another scenario when this feature may prove to be quite handy is when you have to change a system parameter. Suppose you want to increase the size of your flash recovery area. You are in the middle of:
ALTER SYSTEM SET |<-- cursor here in insert mode
Ookey, now what? I think the name of the parameter is something with
recovery... Yeap, it's time for a fuzzy search. Invoke it and type:
recovery. Ups, a lot of items are there: views, synonyms, tables. You can narrow down and refine your search knowing that you're actually looking for a parameter. So, you further type
;:param. Now your search pattern looks like:
recovery;:param. That's nice: I have now just the parameters which contain the word
Now, it's clear that we want
This feature depends on FuzzyFinder plugin so don't forget to install it if you want to have this new vorax feature. You can also customize the search-able database items by modifying the
search.sqlscript located at:
Another improvement is the possibility to invoke describe commands directly from the DbExplorer. It was proposed by Shaun and it makes a lot of sense.
VoraX 2.1 comes also with new syntax files for sql and plsql which means your oracle code will look much better. The sqlplus keywords like
ACCEPT, PROMPTetc. are also highlighted in sql buffers.
That's it for now! Enjoy!