随笔-42  评论-12  文章-0  trackbacks-0

要使一个视图可以被修改,那么这个视图不能包含以下任何一项:

  • Hierarchical query clauses, such as START WITH or CONNECT BY

  • GROUP BY or ORDER BY clauses

  • MODEL query

  • Set operations, such as UNION, UNION ALL, INTERSECT, MINUS

  • Aggregate functions, such as AVG, COUNT, MAX, MIN, SUM, and so on

  • Analytical functions, such as CUME_DIST, and so on

  • A subquery or a collection expression in the SELECT list

  • The DISTINCT operator

  • WITH READ ONLY option

  • The ROWNUM pseudocolumn

posted on 2007-08-09 16:18 tianjuchuan 阅读(254) 评论(0)  编辑 收藏 引用 所属分类: sql
只有注册用户登录后才能发表评论。