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!

Copy/paste sql strings from development ide's.

70626Dec 15 2006 — edited Jun 13 2008
Our team have just started using this tool in favor of the well-known toad. Frist impressions are really good, so keep up the good work! But sometimes you find that a very simple feature has great impact on coding effectiveness.

Very often people copies sql strings from their java development ide's and want to test this in their database tool. For instance:

" SELECT ... " +
" FROM ...." +
" JOIN ...." +
" WHERE ....";

Should become

SELECT ...
FROM ...
JOIN ...
WHERE ....

The same goes backwards, if you write a sql statement in your database tool you would like to quickly convert it to a java string. This perhaps simple, but beloved by us, little feature was available in our previous tool, but I can't find it in sql developer. I've temporarily solved this by using the search-and-replace dialog box with regular expressions. This is however quite awkward to do each time so my options are:

* Assign this search-and-replace operation to a hot key (is this possible?)
* Write an extension (I have trouble finding good documentation of extension development for sql developer)
* Request a feature (will probably take time even if it's accepted)

Could anyone give me some hints on how to solve this?
Or have I missed anything, is it already available somewhere in the tool?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2008
Added on Dec 15 2006
7 comments
1,148 views