You can execute the
CREATE VIEW statement to create a view.
CREATE VIEW view_name AS select_stmt
view_name: the name of the view to be created. You can use the prefix of the database name to distinguish views with the same name within different databases.
select_stmt: the data source of the view.
Create a view named v and set its data source to the customer table.
CREATE VIEW adb_demo.v AS SELECT * FROM customer;