Overview of TABLE FUNCTIONS

Description

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 for defining output columns.
• Requirement to provide XQuery literals

Aliases

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

Functions for returning table schemas

References

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