Database Administrator (DBA) Question:
Explain the use of table functions.
Answer:
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.
| Previous Question | Next Question |
| Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. | Name three advisory statistics you can collect. |