title: oracle query Concatenate all the columns with ','
body: <p>I am using the HR Schema and I would like to concatenate all the columns with ',' for every row.</p>
  
  <p>My code is :</p>
  
  <pre><code>SELECT employee_id || ',' || first_name || ',' || last_name || ',' || email || ',' || phone_number || ','|| job_id || ',' || manager_id || ',' || hire_date || ','
  || salary || ',' || commission_pct || ',' || department_id
  
  THE_OUTPUT FROM employees;
  </code></pre>
  
  <p>Is there a better way (for instance using listagg function) ?
  I am thinking if the table has 1000 columns I can't do the above</p>
  
  <p>Thanks a lot</p>