title: Can any one give me query which one is execute in Oracle 10G
body: <p>I have given both query.the first query is giving proper output(I am using sqlserver).
  and second query i want to execute in Oracle but it is not working.please give me correct query which one i can use in oracle.</p>
  
  <p><strong>SqlServer</strong>:</p>
  
  <pre><code>select * 
  from branch a left outer join course b on a.courseid=b.courseid 
  where b.courseid is NULL
  </code></pre>
  
  <p><strong>Oracle</strong>:</p>
  
  <pre><code>select * 
  from branch a, course b 
  where a.courseid= b.courseid(+) 
  </code></pre>
  
  <p>in oracle this clause where b.courseid is NULL is not working.</p>