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;