A view is a virtual table created from one or more tables or other views. The tables that a view is based on are called base tables. A view does not contain data itself. It lets you query and modify the data in its base tables. The definition of a view is stored in the data dictionary, but the data itself is not stored in the database. A view looks and acts much like a physical table. When you modify data through a view, you are changing the data in the base tables. Conversely, changes to the base table data are also reflected in the view.
In OceanBase Developer Center (ODC), click a connection name to open the connection. In the left-side navigation bar, click the Views tab to view a list of views. Double-click a view name in the list to open the view management page. On this page, you can view the data of the view on the Data tab, or view its basic information, columns, and DDL on the Properties tab.
The database version requirements are as follows:
Database | Version |
OceanBase database Oracle mode | V2.0.0 or later. |
OceanBase database MySQL mode | V1.4.1 or later. |
This chapter describes how to perform the following operations on view objects in ODC: