Returns a multiline record using a function (Function + cursor)

-- Compile a function to obtain empno, ename, Sal, and deptnodrop type emp_row_type in the employee information table; -- 1. Define the Data Type of a set. Create or replace type emp_row_type as object (empno number, ename varchar2 (10), Sal number (), deptno number); -- 2, define the data type of an array of types. You can continuously output the (Table type) Create or replace type emp_table_type as table of emp_row_type; -- 3, create a function, create or replace function getempreturnemp_table_type pipelinedasv emp_row_type; begin for my_row in (select empno, ename, Sal, deptno from Scott. EMP) loop V: = emp_row_type (my_row.empno, my_row.ename, my_row.sal, my_row.deptno); pipe row (V); End loop; return; end;

About copying a table structure

Create Table temp as select * from Scott. EMP where 1 = 2;