Copy/paste sql strings from development ide's.
70626Dec 15 2006 — edited Jun 13 2008Our 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.