title: What are the major differences between the mysql and oracle sql dialects?
body: <p>I am a software developer. I have used mysql for years and now I am about to have my first encounter with oracle in a project.</p>
  
  <p>I was just told that I should be careful that the sql behaves quite differently in some cases. I have no idea what to expect. I am mostly looking for obvious stuff and typical beginner mistakes.</p>
  
  <p>For example I was told that oracle as no auto increment. </p>
  
  <p>That's the type of stuff I am looking for. I'd be grateful for any further knowledge that helps avoid creating new solutions to problems already solved.</p>