You want to write a query. You want to use a subquery in that query. You don’t want to type so much. What to do? Enter the Query Builder. It’s been part of your worksheet for years. Click on it. Drag a table into it. But I don’t want to see the department_id in the output of my query, so …
Oracle SQL Developer: Query Builder Video Demonstration
I’ve talked about the query builder a bit here on these pages, but sometimes a quick video can do a much better job demonstrating these concepts. The video is about 8 minutes and covers: writing a query the old-fashioned way writing a query with drag-and-drop from the tree using the Query Builder At about 5 minutes in, I talk about …
Tag Team your SQL w/the IDE & Visual Query Builder
I’m a keyboard ‘ninja.’ I know how to get a lot of characters to splat up on my screen in as few keystrokes as possible. Yet sometimes I do fall back to the mouse. Cue the command-line SQL*Plus diehards rolling over in their graves. One of my favorite tricks is the ability to drag 2 or more tables into the …