Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Development Guide/ANNOTATIONS. What is "views on tables"?

User_3ABCEApr 20 2023

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".

This post has been answered by Loïc Lefèvre-Oracle on Apr 26 2023
Jump to Answer
Comments
Post Details
Added on Apr 20 2023
1 comment
192 views