Assume a SQL select as below:
select 'abc', cursor(select object_name from user_objects where rownum <= 3) from dual;
the second one in the select list is a cursor, and it will contain a sub-records-set,
my question is, what's the exact feature (terminology) to describe it?
Is there any official document mentioning this in detail?
Thanks.