首页 > IT基础架构 > 网络安全 > Overview of Views (174)

Overview of Views (174)

原创 网络安全 作者:tsinglee 时间:2007-11-10 15:20:06 0 删除 编辑

A view is a tailored presentation of the data contained in one or more tables or other
views. A view takes the output of a query and treats it as a table. Therefore, a view can
be thought of as a stored query or a virtual table. You can use views in most places
where a table can be used.

Because views are derived from tables, they have many similarities. For example, you
can define views with up to 1000 columns, just like a table. You can query views, and
with some restrictions you can update, insert into, and delete from views. All
operations performed on a view actually affect data in some base table of the view and
are subject to the integrity constraints and triggers of the base tables.
You cannot explicitly define triggers on views, but you can define them for the
underlying base tables referenced by the view. Oracle does support definition of
logical constraints on views.

1. 视图是将一个或多个表中的数据进行整理后展现出来 , 可以当作一个表的查询输出
2. 视图可看做存储的查询和虚拟表
3. 视图和表有很多相似的地方 , 如最多可定义1000列 .
4. 对视图的进行dml操作将反应到基表中 .


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量