https://docs.oracle.com/en/database/oracle/oracle-database/23/adfns/registering-application-data-usage-database.html#GUID-7072D6D1-5948-44E4-96DA-58D5B7F2B8EC
The term "Views on Tables" is unclear. Are there views without tables? Oh, yes! You can do select from another view, function, or starting from 23c without FROM at all.
<table_view_type_clause>
probably is sub_type_
of previous <view_type_clause>
(opposition to object view?). But these terms have never been used either in Concepts or SQL Reference. The col_alias_def
does not demonstrate how to specify an ANNOTATION.
It would be clearer if the paragraph mentioned "columns" rather than "views on tables" and "…_view_type_clause".
