ThatJeffSmith

ThatJeffSmith
Navigation
  • SQL Developer
  • ORDS
  • Data Modeling
  • Videos
  • About Me
  • Ask A Question
  • SQL Developer
  • ORDS
  • Data Modeling
  • Videos
  • About Me
  • Ask A Question
query builder

Tag Archive

Below you'll find a list of all posts that have been tagged as “query builder”

How to Build a SubQuery with SQL Developer’s Query Builder

thatjeffsmith November 17, 2016 SQL Developer 5 Comments

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 …

Read More
query buildersqldev

Oracle SQL Developer: Query Builder Video Demonstration

thatjeffsmith March 31, 2014 SQL Developer 8 Comments

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 …

Read More
dragdropjoinquery buildersqldevvideo

Tag Team your SQL w/the IDE & Visual Query Builder

thatjeffsmith May 18, 2012 SQL Developer 2 Comments

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 …

Read More
query buildersqldevworksheet

Subscribe - Posts Emailed To You!

Hi, I’m Jeff

I'm a product manager at Oracle - we want you to be happy using our products.

I publish, on average, 2 posts a week: tips and tricks for Oracle SQL Developer, SQLcl, SQL Developer Data Modeler, and Oracle REST Data Services.

Have a question? Click the 'Ask a Question' link up top!

Your Favorite Posts

  • How to Import from Excel to Oracle with SQL Developer
  • Formatting Query Results to CSV in Oracle SQL Developer
  • Top 10 Preferences to Tweak when using SQL Developer
  • Resetting Your Oracle User Password with SQL Developer
  • Keyboard Shortcuts in Oracle SQL Developer
Other Places to Find Me:

© Jeff Smith and ThatJeffSmith, 2018.

  • Download SQL Developer
  • Developer Tools Message Boards

POWERED BY THE X THEME