title: Comma-Delimited List with "and" concatenated before Last Element in Oracle SQL
body: <p>I've been using LISTAGG to make a comma delimited list for a report, but I have been requested to add "and" before the last element. So right now my output for 3 different cases is:</p>
  
  <pre><code>First, Second, Third
  First, Second
  First
  </code></pre>
  
  <p>But now the desired output is:</p>
  
  <pre><code>First, Second, and Third
  First and Second
  First
  </code></pre>
  
  <p>I thought about doing a Case When, that checks the count and if there are 2, then use 'and' as delimiter, but how could I go about doing this for more than 2 elements? </p>
  
  <p>Thanks</p>