Explain the use of table functions. | Oracle 10g Interview Questions

 Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.