We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Oracle table function ?

MIHIR KAR
MIHIR KAR asked
on
101 Views
Last Modified: 2017-05-30
Hello sir/mam i hava a doubt on when to use oracle table pipeline function .What are the benifits ?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
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
EE Topic Advisor
CERTIFIED EXPERT
Most Valuable Expert 2014
Awarded 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.