title: oracle c# how to bind a variable with like
body: <p>I have this query</p>
  
  <pre><code> string query = "SELECT * from IMALSO3.V_BN_IVR_ACCT_BAL_MNO WHERE PHONENO Like '%':mobileNumber";
  
                      using (OracleCommand cmd = new OracleCommand(query, conn))
                      {
                          cmd.Parameters.Add("mobileNumber", phone8Digits);
  </code></pre>
  
  <p>but it seems that i am binding wrong, </p>
  
  <p>what is the correct way plase?</p>
  
  <p>thanks</p>