oracle function return array of number

Solutions on MaxInterview for oracle function return array of number by the best coders in the world

showing results for - "oracle function return array of number"
Alma
28 Nov 2016
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);