title: outer join in oracle sql
body: <p>I did searches for oracle sql outer joins to see whether there is a shotcut (like I think in mysql you can do where a *= b I believe, which could do an outer join).  I found one thing that looked promising but didn't work.  I am trying to find a shortcut because I can never remember the outer join syntax.  I have to look it up all the time.  Take this for example:</p>
  
  <pre><code>SELECT
    l.*,
    r.*
  FROM database.login l LEFT OUTER JOIN database.relation r
      ON l.user_id = r.user_id
         AND r.user_id IS NULL
  </code></pre>
  
  <p>Several values of r.user_id were null as expected.  I tried what I read somewhere:</p>
  
  <pre><code>SELECT
    l.*,
    r.*
  FROM database.login l, database.relation r
  WHERE l.user_id = +r.user_id
  </code></pre>
  
  <p>but that did not select rows from database.relation that did not have a user_id matching database.login.</p>
  
  <p>So do you have to type that whole syntax?  I am trying to get an entry in login not in relation.</p>
  
  <p>I suppose I could use something like the following:</p>
  
  <pre><code>u.user_id not in select user_id from database.relation
  </code></pre>
  
  <p>if necessary</p>