返回多个值的Oracle函数

SQL> create or replace
  2  type three_values as object
  3    ( val_1 int,
  4      val_2 date,
  5      val_3 varchar2(10)
  6    );
  7  /

Type created.

SQL>
SQL> create or replace
  2  function f return three_values is
  3  begin
  4    return
  5      three_values(1,sysdate,'hello');
  6  end;
  7  /

Function created.

SQL>
SQL> select f from dual;

F(VAL_1, VAL_2, VAL_3)
-------------------------------------------------------------
THREE_VALUES(1, '06-SEP-17', 'hello')

1 row selected.

SQL>
SQL> select x.c.val_1, x.c.val_2, x.c.val_3
  2  from
  3   (select f c from dual ) x;

   C.VAL_1 C.VAL_2   C.VAL_3
---------- --------- ----------
         1 06-SEP-17 hello

1 row selected.