By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create or replace type numval_type as table of VARCHAR2(30);
CREATE OR REPLACE FUNCTION get_tab_ptf (p_rows IN NUMBER)
RETURN numval_type PIPELINED AS
BEGIN FOR i IN 1 .. p_rows
LOOP
PIPE ROW('Value is '||i);
END LOOP;
RETURN;
END;
/
select * from TABLE(get_tab_ptf(100));
| COLUMN_VALUE |
|---|
| Value is 1 |
| Value is 2 |
| Value is 3 |
| Value is 4 |
| Value is 5 |
| Value is 6 |
| Value is 7 |
| Value is 8 |
| Value is 9 |
| Value is 10 |
| Value is 11 |
| Value is 12 |
| Value is 13 |
| Value is 14 |
| Value is 15 |
| Value is 16 |
| Value is 17 |
| Value is 18 |
| Value is 19 |
| Value is 20 |
| Value is 21 |
| Value is 22 |
| Value is 23 |
| Value is 24 |
| Value is 25 |
| Value is 26 |
| Value is 27 |
| Value is 28 |
| Value is 29 |
| Value is 30 |
| Value is 31 |
| Value is 32 |
| Value is 33 |
| Value is 34 |
| Value is 35 |
| Value is 36 |
| Value is 37 |
| Value is 38 |
| Value is 39 |
| Value is 40 |
| Value is 41 |
| Value is 42 |
| Value is 43 |
| Value is 44 |
| Value is 45 |
| Value is 46 |
| Value is 47 |
| Value is 48 |
| Value is 49 |
| Value is 50 |
| Value is 51 |
| Value is 52 |
| Value is 53 |
| Value is 54 |
| Value is 55 |
| Value is 56 |
| Value is 57 |
| Value is 58 |
| Value is 59 |
| Value is 60 |
| Value is 61 |
| Value is 62 |
| Value is 63 |
| Value is 64 |
| Value is 65 |
| Value is 66 |
| Value is 67 |
| Value is 68 |
| Value is 69 |
| Value is 70 |
| Value is 71 |
| Value is 72 |
| Value is 73 |
| Value is 74 |
| Value is 75 |
| Value is 76 |
| Value is 77 |
| Value is 78 |
| Value is 79 |
| Value is 80 |
| Value is 81 |
| Value is 82 |
| Value is 83 |
| Value is 84 |
| Value is 85 |
| Value is 86 |
| Value is 87 |
| Value is 88 |
| Value is 89 |
| Value is 90 |
| Value is 91 |
| Value is 92 |
| Value is 93 |
| Value is 94 |
| Value is 95 |
| Value is 96 |
| Value is 97 |
| Value is 98 |
| Value is 99 |
| Value is 100 |