Explain The Use Of Table Functions.

1.	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. 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.

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

Name Two Files Used For Network Connection To A Database.
How Can You Gather Statistics On A Table?
You Have Just Compiled A Pl/sql Package But Got Errors, How Would You View The Errors?
Explain What Partitioning Is And What Its Benefit Is.
How Can You Rebuild An Index?
How Would You Determine Who Has Added A Row To A Table?
What View Would You Use To Determine Free Space In A Tablespace?
What View Would You Use To Look At The Size Of A Data File?
How Do You Resize A Data File?
How Do You Add A Data File To A Tablespace?

Explain The Use Of Table Functions.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment