
I imported back into SQLDev, no complaints or errors, but the shortcut is still not assigned Nevertheless I tried to assign the shortcut by addding the following section in the exported shortcuts file and then importing it back (I deducted the command by looking at other commands and their name in the exported file, maybe I got it wrong) xml file to see if I can configure it there manually and then import it back, however it exports only defined shortcuts, so can not add new shortcuts for non assigned commands through editing the xml file. I get the Shortcut Keys window, search for “comme”, the results show up, click on “Toggle Multiline Comments”, click down on “New Shortcut” and type CTRL+Minus, the keystroke gets registered in the New Shortcut filed, click on Assign button, but then nothing happens (the assigned shortcut should appear in the “Shortcut” column on the “Toggle Multiline Comments” row. Today I wanted to add another one (command “Toggle Multiline Comments”, which doesn’t have assigned shortcut) and SQLDev is not assigning the new shortcut. I did modify a few shortcuts and are working fine. Thanks! (version 19.2.1.247, and NO control over which version I use). Is this hard-coded in SQL Developer? Can I not change this functionality? It’s a bit of a mind-twist to have to do something differently in SQL Developer than I do in every other tab-based app I use in Windows. In the Shortcuts assignment dialog, I can see that my reassignment is there, but functionally, ctrl+tab/ctrl+shift+tab have retained the Next/Previous FILE behavior. So… I tried exporting the shortcut keys to XML, changed the file so that ctrl+tab/ctrl+shift+tab are now Next PANE and Previous PANE (which is the functionality I’m looking for), and imported the XML back in.
ORACLE SQL DEVELOPER LOGO WINDOWS
This is frustrating, especially when every other Windows app I use works the “standard” way.

The way that works (I’m sure you know) is that one press does nothing, then another brings up a small dialog where you can cycle through open tabs and when you release ctrl, it shifts focus to that tab. Yes, SQL Developer sort of does this it’s assigned to “Next File” in Preferences / Shorcut Keys. One thing that MOST tabbed windows do is use ctrl+tab to cycle through tabs.

Yes, I am someone that is used to never having to touch the mouse, but in SQL Developer, I’m still not quite there. Jeff, as I’ve made the transition from SQL Server to Oracle, your blogs have been very helpful. But, you already know your favorites, yes? For the 5-6% of our users out there who use Macs 🙂 I’ll use the most popular shortcut mentioned in the comments to round out my Top 10 list above! I know, I know, I forgot your FAVORITE ONE. If your fingers have already memorized some keystrokes, just re-program SQL Developer to match! What’s your favorite shortcut? Then I blog about them, like they’re ‘magic.’ #EvilLaughīut the main tip is this – don’t let your previously memorized keyboard shortcuts SHORTCUT your usage of SQL Developer.
ORACLE SQL DEVELOPER LOGO CODE
When I get ‘bored’ or if I think I might be missing something, I peruse the Code Editor and Other categories, again! I’ve picked up quite a few cool editor tricks here. Be nice – share! You can save your new mappings with your co-workers using the Export and Import buttonsĬlick on ‘More Actions’ to expose the Import and Export buttons.Mind the conflicts when you change the defaults.Pay special attention to the ‘Code Editor’ and ‘Other’ categories.Search by command name OR the keystroke itself Alt+PageUp takes you back up in the opposite directionĬonfiguring Keyboard Shortcuts in SQL Developer Alt+PageDown: Will take focus from worksheet edit area to results pane.


And of course we all know what F1 does, right? Right?!?
ORACLE SQL DEVELOPER LOGO MAC OS
For example, I’ve personally JUST memorized the Cmd-Shift-4 ‘trick’ in Mac OS X. While some of us may be keyboard ninjas, and others are more driven to use the mouse – everyone has probably picked up a few strategic keyboard shortcuts over the years. These are the driving questions for today’s post. The CTRL key, which stands for ConTRoL…aw, the good ole days 🙂What keyboard shortcuts should EVERY Oracle SQL Developer user know? How do you find new shortcuts to master, and how do you change them to match ones you’ve already learned in other tools?
