ThatJeffSmith

30 SQL Developer Tips in 30 Days, Day 1: Help with WHERE Clauses

For the month of September I’m challenging myself to perform two different feats of strength:

  1. Do 5,000 push-ups in the month of September
  2. Post a SQL Developer Tip or Trick every day for the next 30 days

I’ve noticed my posts are starting to go out once or twice a week, and I like to average three. So hopefully this mini-bootcamp of blog posts will me back on schedule.

So, without further ado, Tip #1:

How to Get Help with your WHERE Clauses

It’s all about the cursor.

If you type ‘WHERE’ and invoke the helper, via Ctrl+Spacebar:

Here are some code samples from the Oracle Docs

Here are some code samples from the Oracle Docs

If you type ‘WHERE ‘ and invoke the helper:

May we JOIN you?

May we JOIN you?

Note the space after the WHERE when invoking the helper.

Since I’ll be blogging a tip or trick every day for the next 30 days, most of these will be shorter and easier for you to digest, I hope!