title: select only first letters of words from a varchar field
body: <p>I was asked in an interview,a question from oracle sql.this seemed to be a simple question but  i had no clue to answer.could anybody help?</p>
  
  <p>if there is string like "newyork is a beautiful city" in a colum.</p>
  
  <pre><code>select column_name from table_name;
  </code></pre>
  
  <p>will result</p>
  
  <pre><code>newyork is a beautiful city
  </code></pre>
  
  <p>what is the query required to give the output as a string with all the first letters.
  i.e., the output should be </p>
  
  <pre><code>niabc
  </code></pre>