title: How to append a string to where clause in APEX Interactive Report SQL
body: <p>I am a newbee in Apex and I am using apex 5.1.3. I am creating a report through sql query and where clause of the query should be dynamic which needs be taken from another table column. On page load i loaded this where condition string from table and set that as page item <strong>:P5_NEW</strong></p>
  
  <p>I tried like this:</p>
  
  <p><strong>select * from EMPLOYEES where :P5_NEW</strong></p>
  
  <p>Page item <strong>:P5_NEW</strong> contains the string which should be appended to where clause. But apex throws error <strong>ORA-00920: invalid relational operator</strong>.</p>
  
  <p>Can some one please advice how I can append a string to where clause in APEX report query?</p>
  
  <p>Thanks</p>