title: Problem while updating table in android
body: <p>I created a table in the database that has the data like this:<img src="https://i.stack.imgur.com/C3clw.jpg" alt="enter image description here"></p>
  
  <p>Now i have written a query that updates the contact field by concatinating name and email fields:
  <code>UPDATE MyContacts SET contact=(SELECT name||'--'||email FROM MyContacts);</code></p>
  
  <p>Here the problem is after executing the query the table is as below:</p>
  
  <p><img src="https://i.stack.imgur.com/nDEVZ.jpg" alt="enter image description here"></p>
  
  <p>Why is it happening like this? In oracle i never faced this problem. Please help me. Thank you</p>