1.测试表表结构如下

2.表中数据如下

3.开始实验视图使用中的一些注意事项
实验一：

Rules for Performing DML Operations on a View

You cannot add data through a view if the view includes:
Group functions
A GROUP BY clause
The DISTINCT keyword
The pseudo column ROWNUM keyword
Columns defined by expressions
NOT NULL columns in the base tables that are not selected by the view

(以上内容出自官网文档)

your support will encourage me to continue to create!
版权声明:自由转载-非商用-非衍生-保持署名(创意共享3.0许可证)