title: Missing expression Oracle Query
body: <p>I have a oracle trigger and it returns the error <br></p>
  
  <blockquote>
    <p>Additional information: ORA-00936: missing expression</p>
  </blockquote>
  
  <p>In my TOAD it shows me the below line.</p>
  
  <pre><code>EXECUTE IMMEDIATE 'UPDATE TBL_NEWS_TYPE SET FULLNAME='|| newsName ||' WHERE ID = SELECT MAX(ID) FROM TBL_NEWS_TYPE)';
  </code></pre>
  
  <p>In here <strong>newsName</strong> is varchar2 variable like newsName VARCHAR2(50) / and ID in INTEGER.</p>