CREATE OR REPLACE FUNCTION ListeFormation(pr IN Formation.prix%type)
   RETURN TABLE_RES
   PIPELINED
AS
   CURSOR CURSEUR_form
   IS
      SELECT *
        FROM Formation
        WHERE prix = pr;
BEGIN
   FOR f IN CURSEUR_form
   LOOP
      PIPE ROW (TABLE_RES (f.codformt, f.titre, f.descform, f.prix));
      EXIT WHEN CURSEUR_form%NOTFOUND;
   END LOOP;

   RETURN;
END;
/

La source de l'exemple est: https://stackoverflow.com/questions/46993559/return-a-table-in-a-pl-sql-function