title: Hardcode value of column name and column in select query with pipe delimiter
body: <p>I want to hard-code a column name and its value as <code>New York</code> in a select query with pipe delimiter. E.g. <code>Emp</code> table has columns <code>EmpId</code>, <code>EmpName</code>, <code>Salary</code>. I want output such as </p>
  
  <pre><code>Select EmpId ||'|'||
         EmpName ||'|'||
         'NewYork' as City  ||'|'||
         Salary
   from Emp
  </code></pre>
  
  <p>Here I want <code>City</code> column in output query and its value should be <code>'NewYork'</code> for each record.</p>
  
  <p>Here I am getting error as <code>"FROM keyword not found where expected"</code>. When I use comma instead of Pipe Delimiter I am getting result but not with Pipe. Please advise. Thanks in advance.</p>