title: is there a PRODUCT function like there is a SUM function in Oracle SQL?
body: <p>I have a coworker looking for this, and I don't recall ever running into anything like that.</p>
  
  <p>Is there a reasonable technique that would let you simulate it?</p>
  
  <pre><code>SELECT PRODUCT(X)
  FROM
  (
      SELECT 3 X FROM DUAL
      UNION ALL 
      SELECT 5 X FROM DUAL
      UNION ALL
      SELECT 2 X FROM DUAL
  )
  </code></pre>
  
  <p>would yield 30</p>