Answers for "HOW TO CREATE TABLE FUNCTION RETURN IN ORACLE SQL"

SQL
4

oracle function return table

CREATE TYPE object_row_type as OBJECT (
  object_type VARCHAR(18),
  object_name VARCHAR(30)
);

CREATE TYPE object_table_type as TABLE OF object_row_type;

CREATE OR REPLACE FUNCTION get_all_objects 
  RETURN object_table_type PIPELINED AS
BEGIN
    FOR cur IN (SELECT * FROM all_objects)
    LOOP
      PIPE ROW(object_row_type(cur.object_type, cur.object_name));   
    END LOOP; 
    RETURN;
END;

SELECT * FROM TABLE(get_all_objects);
Posted by: Guest on August-15-2021

Code answers related to "HOW TO CREATE TABLE FUNCTION RETURN IN ORACLE SQL"

Code answers related to "SQL"

Browse Popular Code Answers by Language