The recursive statement is a SELECT statement that retrieves row data from a join of the named query and other tables.
You cannot include NORMALIZE in a recursive statement of a recursive query.
- *
- All columns of all tables referenced in the FROM clause of the recursive statement be returned.
- seed_selection
- Any valid SQL expression, with these exceptions:
- Aggregate functions
- Ordered analytical functions
- AS
- Optional introduction to expression_alias_name.
- expression_alias_name
- Alias for the expression.
- table_name
- Name of the named query or the name of a table or view.
- FROM
- Introduction to the named query and one or more tables or views from which expression is to be derived.
- where_search_condition
- A conditional search expression that must be satisfied by the row or rows returned by the recursive statement.