I have some code… BEGIN give_raises(); END; / I can guess that GIVE_RAISES is a procedure of some kind. But now I want to open it, or ‘go to it’ or ‘step into it.’ And I want to do so without having to pick up my mouse. So I could tell you about the Ctrl+Click trick, but that’s all mouse. …
Video! Using the Keyboard Shortcuts in Oracle SQLcl
Developers hate using a mouse. Sticking with the keyboard reminds everyone we bled all over our keyboards 20 years ago in VT100 terminals. So we built a modern command line interface for Oracle Database and released it last year, in 2016. And knowing you already know and love the keyboard, we made sure you could do what you needed to …
Toggling Between SQL Worksheet Result Panels
I’ve talked about keyboard shortcuts before… But What About Going From One Data Grid to the Next? Apparently I neglected to show that one. Move Right: ALT+SHIFT+F5 Move Left: SHIFT+F5 Just so you know I’m not making this up..
Keyboard Shortcuts Cheat Sheet
Remember back when Corel first released WordPerfect? Remember how it had like a bazillion keyboard shortcuts, and you needed help remembering them all? No? You probably also don’t remember a world sans e-mail and smart phones either. Oh well. Anyways, we have lots of keyboard shortcuts in SQL Developer and a few in SQLcl. You might need help remembering them. …
Keyboard Shortcuts in Oracle SQL Developer
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? These are the driving questions for today’s post. While some of us may be keyboard ninjas, and others are more driven to use the mouse – everyone …
SQL Developer Quick Tip: Accessing SQL History with the Keyboard
When I’m doing my ‘Tips and Tricks’ show, there is at least one trick that is guaranteed to get the audience’s attention: I’m in an editor – INSERT MAGIC – wham! I’m cycling through the SQL History list, no need to use the mouse. Here’s a set of keyboard shortcuts I want you to memorize RIGHT NOW: Ctrl+Down — Next …
Code Completion Insight with Oracle SQL Developer
Most third generation language (3GL) IDEs have trained hackers like me to expect the tool to write some of the code for them. Regular internet folks are already used to having search terms and URLs auto-completed in their browsers. I don’t want to get into a debate over whether this makes us lazier AND dumber, but I DO want to …