We would like to show you a description here but the site won#t allow us.
, This guide contains the information about tables within Oracle Sales Cloud and their columns, primary keys, and indexes.
The guide also includes the information about views within Oracle Sales Cloud along with the columns and queries associated with each view.
, Sounds to me like you want a pipelined table function.
These return a table of your record type.
Which you can query with the table operator: create or replace package pkg as type rec is record ( c1 int, c2 int ); type rec_tab is table of rec; function f ( num_rows int ) return rec_tab pipelined; end; / create or replace package body pkg as function f ( num_rows int ) return rec_tab pipelined.