ThatJeffSmith

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 why I think ANY SQL Developer user can get value from the Query Builder – not just the n00bs.

What I Didn’t Show

I showed how nice it is when you ALREADY have referential integrity defined and enforced in the database via foreign key constraints. But sometimes…well, sometimes those aren’t there.

You can still use the Query Builder.

And, you can modify the joins to do OUTER joins.

Drag and drop between columns to create the join - double click on the join to make it left or right outer

Drag and drop between columns to create the join – double click on the join to make it left or right outer

So next time you have to write that beautiful 15 table join SELECT, why not give the Query Builder a try?