Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pipeline a sql query without creating a type

kaericnDec 28 2017 — edited Dec 29 2017

Greeting community.

I like to create a pipeline anonymous block for a sql.

And my requirement is to able to pipeline the output without creating a type.

I have done some researches but all the existing example requires to use a user-defined type.

Is it possible to do pipeline without creating a user defined type??

https://oracle-base.com/articles/misc/pipelined-table-functions

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2018
Added on Dec 28 2017
10 comments
1,053 views