In the view synopsis shown below, the CREATE VIEW statement is used to create a view, if the REPLACE keyword is used, the view will be replaced if it already exists. View attribute names can be given explicitly, or they can be inherited from the SELECT statement:
CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ]
[ WITH ( view_option_name [= view_option_value] [, ... ] ) ]
AS query
[ WITH [ CASCADED | LOCAL ] CHECK OPTION ]
The synopsis of materialized views differs from the view synopsis. Please refer to the Materialized views section for the materialized view synopsis.
The following example shows how to create a view that lists only the user information without the password. This might be useful for implementing data authorization to restrict applications from accessing the password. Note that the...
