Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto Replace functionality similar to TOAD

274137Jan 25 2006 — edited Jan 27 2006
I'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).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2006
Added on Jan 25 2006
2 comments
530 views