Auto Replace functionality similar to TOAD
274137Jan 25 2006 — edited Jan 27 2006I've played with Raptor 804 for a few hours now. Only a couple things keeping me from being able to move (comfortably) to Raptor from Toad at this point.
1) Bind Variables not remembering values if I run queries repetively. Other posts address that issue
2) The other is Toad's Auto Replace feature. I have huge library built where I can type in a few letters and when I hit the space bar (or other set characters) the characters are replaced with something else. ie...I type "srf" and I get "select a.*, a.rowid from" or I type "hca" and I get the table name "ar.hz_cust_accounts" etc....
Because I've got so many auto replace keystrokes saved I am able to type out ad-hoc queries in a hurry. I see Raptor has an Accelerators option under Preferences but that doesn't do quite what I want.
3) Other very nice to have (because of the way I work) is the Named Sql options that is available in Toad. Basically instead of having a bunch of standard queries that I use all the time saved into files, I've got them saved in my Named Sql's in Toad so I can quicly pop them up (with a shortcut keystroke Ctrl-N) and then click on the one similar to the Sql History window. In conjunction with the bind variable functionality listed in item 1, it helps me investigate things very quickly when researching issues.
Initial results on Raptor look good. I'm looking forward to it improving to the point where I can ditch Toad (which I've lost all faith in).