Link to home
Avatar of MIHIR KAR
MIHIR KARFlag for India

asked on

Oracle table function ?

Hello sir/mam i hava a doubt on when to use oracle table pipeline function .What are the benifits ?
Avatar of schwertner
schwertner
Flag of Antarctica image

The benefits are that in fact you do not use a table as source of data, you only mimic a table.
The disadvantage is that the result resides in the RAM, so big amount of input data will need more RAM

https://oracle-base.com/articles/misc/pipelined-table-functions
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial