An inline view is basically a subquery, except it is always in the FROM clause of a SQL statement.
Some database implementations, like Oracle, allow you to use a subselect in the FROM clause of a query. This SQL construct is also known as inline view, and it lets the subquery to be treated like a predefined view or table, even though an inline view is not predefined.
Read full article from SQL Inline View
Some database implementations, like Oracle, allow you to use a subselect in the FROM clause of a query. This SQL construct is also known as inline view, and it lets the subquery to be treated like a predefined view or table, even though an inline view is not predefined.
Read full article from SQL Inline View
No comments:
Post a Comment