Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE OR REPLACE TYPE LISTE_VALUES AS TABLE OF VARCHAR2(2000);
/    
CREATE OR REPLACE FUNCTION f_get_val (
     pi_1   IN VARCHAR2,
     pi_2   IN NUMBER,
     pi_3   IN VARCHAR2
) RETURN liste_values
     PIPELINED
IS   l_list liste_values;
     w_row_count   NUMBER := 0;
BEGIN
          for cur in
          ( SELECT 'LINE' || level as value
          FROM dual CONNECT BY
               level <= 20
               ) loop
              PIPE ROW ( cur.value );
                        w_row_count := w_row_count + 1;
          end loop;
     dbms_output.put_line('There were ' || w_row_count || ' rows selected');
END f_get_val;
/
select * from TABLE(f_get_val('1',1,2));


COLUMN_VALUE


LINE1

LINE2

LINE3

LINE4

LINE5

LINE6

LINE7

LINE8

LINE9

LINE10

LINE11

LINE12

LINE13

LINE14

LINE15

LINE16

LINE17

LINE18

LINE19

LINE20