And of course we all know what F1 does, right? Right?!?Either way, Excel inserts a row above the current row or cell. For example, I’ve personally JUST memorized the Cmd-Shift-4 ‘trick’ in Mac OS X. This is the exact same function as hitting the Home button on a Windows PC.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. The ‘fn’ key on the Mac keyboard is the function button, hitting that with the left arrow will immediately jump to the very top of a page in the active application of Mac OS.F5 : executes the current code as a script ( think SQL*Plus) ctrl-enter : executes the current statement(s) My Favorite SQL Developer Shortcuts shift+F4 : opens a Describe window for current object at cursor ctrl-shift+Up/Dn : same as above but appends instead of replaces ctrl-Up/Dn : replaces worksheet with previous/next SQL from SQL History
![]() Control Shift 4 Excel Equivalent Mac OS XBe nice – share! You can save your new mappings with your co-workers using the Export and Import buttonsClick on ‘More Actions’ to expose the Import and Export buttonsWhen 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. Mind the conflicts when you change the defaults Pay special attention to the ‘Code Editor’ and ‘Other’ categories Alt+PageUp takes you back up in the opposite directionConfiguring Keyboard Shortcuts in SQL DeveloperSearch by command name OR the keystroke itself Why is it that when i drage a file into my my passport for mac itb hard drive it copies itOne 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. But, you already know your favorites, yes? For the 5-6% of our users out there who use Macs □Jeff, as I’ve made the transition from SQL Server to Oracle, your blogs have been very helpful. If your fingers have already memorized some keystrokes, just re-program SQL Developer to match! What’s your favorite shortcut?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. ![]() 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)I imported back into SQLDev, no complaints or errors, but the shortcut is still not assignedThis is what I have in the logging page, maybe it’s relevant:SEVERE 5288 17952 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.ide.keyboard.KeyStrokePanel.whenAdd(KeyStrokePanel.java:753)I’m on SQL Developer Version 18.3.0.277 Build 277.2354 on Windows 10 Pro 64bit. 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. 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 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.I tried to export the shortcuts to. Thanks! (version 19.2.1.247, and NO control over which version I use).I did modify a few shortcuts and are working fine. 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.
0 Comments
Leave a Reply. |
Details
AuthorEmily ArchivesCategories |