oracle function return multiple rows

Solutions on MaxInterview for oracle function return multiple rows by the best coders in the world

showing results for - "oracle function return multiple rows"
Sasha
25 Jan 2018
1CREATE TYPE object_row_type as OBJECT (
2  object_type VARCHAR(18),
3  object_name VARCHAR(30)
4);
5
6CREATE TYPE object_table_type as TABLE OF object_row_type;
7
8CREATE OR REPLACE FUNCTION get_all_objects 
9  RETURN object_table_type PIPELINED AS
10BEGIN
11    FOR cur IN (SELECT * FROM all_objects)
12    LOOP
13      PIPE ROW(object_row_type(cur.object_type, cur.object_name));   
14    END LOOP; 
15    RETURN;
16END;
17
18SELECT * FROM TABLE(get_all_objects);