One option is setting your own code in snippet.
Navigate through View->Snippets->Add.
And you can drag n drop the snippet you created any time
Hope this would help you.Try this.
Thanks true, but I am using Snippets but every time drag the select * from command
Need to think... Some other easy option like Toad just ctrl+space+enter will get command...
as an alternative, you can also drag a table from the navigator to the worksheet. It has extra features like:
- make insert, update and delete statements
- when selecting multiple table, joins are made.
1 person found this helpful
It's already there...basically
This activates the SQL Editor code templates - much better than snippets, b/c no mouse needed.
I talk about this feature here, short video as well.
Jeff nice tip, but some time it takes time to get the values...
Sorry for comparing the with toad is very easy .. Then ctrl+space.. :-)
it's instantaneous for me, don't put a space after the 'ssf' or whatever your template name is, and it should replace immediately after hitting the kb shortcut
i am not able to type key d i am getting waiting for more keystroke : D ,some error message
I.e. when i pressed d it showing below waiting for d waiting for more keystroke : D
How to reset my sql developer ..
key d is not working and not able enter the letter d why .,...
i able to type d letter , i change the option in More Actions as Load Keydoare schema as Default MacoOX