Overview of TABLE FUNCTIONS

Purpose

Table functions are used to convert data sources such as JSON, XML, or external files into queryable relational rowsets.

Common table function entries in Oracle-compatible mode include:

• JSON_TABLE(...)
• XMLTABLE(...)
• FILES(...)

Syntax characteristics (Oracle-compatible mode)

Common entry points

• JSON_TABLE(...)
• XMLTABLE(...)
• FILES(...)

Key capabilities of XMLTABLE

• Support for the XMLNAMESPACES namespace declaration.
• Support passing XML data using PASSING
• Support the COLUMNS clause to define output columns.
• Requirement to provide XQuery literals

Alias

In Oracle-compatible mode, you do not need to explicitly specify an alias; the system can generate one if not provided.

Functions for returning table schemas

References

• JSON_TABLE (Oracle-compatible mode)
• XMLTABLE
• FILES table function
• SELECT Statement (Oracle-compatible mode)
• LOAD DATA Statement (Oracle-compatible mode)