title: ORA-01795: maximum number of expressions in a list is 1000 , how to split the string
body: <p>How to split the following string?</p>
  
  <pre><code>      A.x IN (changeList),
  </code></pre>
  
  <p>changeList has the following value, so that it makes the clause like this:</p>
  
  <pre><code>       A.x IN (HEXTORAW('1E2956B9266F11DDA85810000000C959'),HEXTORAW   
               ('ADD834AD6A3911DF923C10000000C959'),HEX...........
  </code></pre>
  
  <p>The above IN has more than 1000 values and hence ORA-01795 error, how to modify it so that i have </p>
  
  <p>A.X IN (id1, ..id999) OR A.x IN (id1000,...), Any c code would help me...</p>