adspace


Explain the use of table functions.

Answer Posted / Rohit Kumar Rai

Table functions are Oracle PL/SQL functions that return a result set. They can be used to encapsulate complex logic, reusable queries, or derived tables. Table functions can be used in FROM clauses, like regular tables, and can accept parameters. They can be declared as deterministic (always returning the same output for the same input) or non-deterministic (returning different outputs for the same input).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2372


please send me oracle pl/sql exp resume. and also faqs...

2588