title: Function return sys_refcursor call from sql with specific columns
body: <p>This may find little silly, but I would like to know whether this is possible.</p>
  
  <p>I have a function which return sys_refcursor</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION get_employee_details(p_emp_no IN EMP.EMPNO%TYPE)
     RETURN SYS_REFCURSOR
  AS
     o_cursor   SYS_REFCURSOR;
  BEGIN
     OPEN o_cursor FOR
        SELECT EMPNO,
               ENAME,
               JOB,
               MGR,
               HIREDATE,
               SAL,
               COMM,
               DEPTNO
          FROM emp
         WHERE EMPNO = p_emp_no;
  
     RETURN o_cursor;
   -- exception part
  END;
  /
  </code></pre>
  
  <p>and I could get the results using</p>
  
  <pre><code>select  get_employee_details('7369') from dual;
  </code></pre>
  
  <p>Is it possible to get the result from the above function by specifying column name?
  E.g. If I would want to get ename or salary, how could I specify in the sql statement without using a plsql block?
  Something like </p>
  
  <pre><code>select  get_employee_details('7369') &lt;specific column&gt; from dual;
  </code></pre>