title: Embedded SQL vs Dynamic SQL
body: <p>I am currently doing a *cough*Oracle*cough* database subject. The lecturer is introducing <a href="http://en.wikipedia.org/wiki/Embedded_SQL" rel="nofollow">embedded SQL</a> as the way you get other languages (e.g. C, C++) to interact with the (Oracle) database.</p>
  
  <p>I have done some database work myself (on mysql) where I use dynamic sql.</p>
  
  <p>As embedded SQL seems to be limited to a few Oracle and a few others, so is this more an attempt at lock-in, or is there real value in embedded SQL?</p>
  
  <p><strong>Edit:</strong> I just realized that the fact this lesson was right after a lesson on PL/SQL may be important.</p>
  
  <p><strong>Original question</strong> asked about parameterized SQL (now replaced by "dynamic sql" to improve question).</p>
  
  <p><strong>Aside:</strong> I am thinking that the ~$30 "SQL and relational theory" book I bought is teaching me more than this database class. </p>