Articles Related
Syntax
CREATE VIEW <view_name> [COMMENT <string_literal>]
[(<column_name_list>)] AS <subquery> [<with_association_clause>]
-- Data Security
[WITH MASK (<column_name> USING <mask_expression> [,...])]
[WITH STRUCTURED PRIVILEGE CHECK]
-- Cache
[WITH [<cache_type>] CACHE [RETENTION] <minute_value> [OF <projection_list>]]
[FILTER <filter_condition>]
[FORCE]
-- Data Check integrity when inserting / updating
[WITH CHECK OPTION]
where:
- MASK is data masking for contents to transform confidential data so that it appears meaningless to users
- PRIVILEGE if an SQL-based analytic privilege must be needed to access this view.
- CACHE data cache gestion
- FILER reduces the cached data by specifying a filter condition.
- FORCE: forces the addition of a cache without checking its cachability
Metadata
select * from VIEW_COLUMNS where view_name = 'NAME'
select * from VIEWS
where: