title: Missing Keyword when trying to Select into
body: <p>So I have a function to return an Average of a column such as </p>
  
  <pre><code>CREATE OR REPLACE FUNCTION avgCol
  RETURN DEC IS avgNum DEC;
  BEGIN
    SELECT AVG(myCol)
    INTO avgNum
    FROM MyTable;
    RETURN avgNum;
  END;
  /
  </code></pre>
  
  <p>While trying to test the results, i have the following</p>
  
  <pre><code>SELECT avgCol
  INTO RESULT
  FROM DUAL;
  </code></pre>
  
  <p>but it gives me the error</p>
  
  <pre><code>ORA-00905: missing keyword
  00905. 00000 -  "missing keyword"
  *Cause:    
  *Action:
  Error at Line: 175 Column: 6
  </code></pre>
  
  <p>Where line 175 is <code>INTO RESULT</code>. As far as I know, this is a scalar function and I'm trying to return a signal variable so it should work right? What keyword am I missing here?
  Also I know I can just use AVG(), but I am learning how to create a scalar function. this is strictly for learning purposes.</p>