Oracle complex类型,什么是complex view,和一般的view有什么区别？

I think it's a general relational database concept. This document has a good definition:

http://www.laku.net/ASPdotNET/sql_4.ppt

"There are two classifications for views: simple and complex. The basic difference is related to the DML (insert, update, and delete) operations.

A simple view is one that:

Derives data from only one table

Contains no functions or groups of data

Can perform DML through the view

A complex view is the one that:

Derives data from many tables

Contains functions or groups of data

Does not always allow DML through the view "

If you read the PPT, the wording is slightly different. For instance, it says a complex view is built on one or more tables, i.e. even one table is possible. I guess the most important part is that the view definition uses functions or group-by. If one of the two conditions is met, it's a complex view. One table or not, it doesn't matter.

Yong Huang