1.创建视图
create or replace view acct
as
select id,iname from test1;
2.查询视图详细信息
select view_name,text from user_views;
3.创建with check option视图(可同步原表)
create view v_test2 as select * from test2
with check option constraint p_pk1
4.创建带with read only的视图
create or replace view v_test2 as select * from test2
where id>10 with read only
5.内嵌式视图(把子查询放在from里面)
内嵌式视图不属于任何用户,也不是对象。
前n行查询分析:rownum,与子查询语句联合使用.
select rownum,id from(select id from test order by id asc) where rownum<4;
(rownum是一个伪劣,不是真实的列)
create or replace view acct
as
select id,iname from test1;
2.查询视图详细信息
select view_name,text from user_views;
3.创建with check option视图(可同步原表)
create view v_test2 as select * from test2
with check option constraint p_pk1
4.创建带with read only的视图
create or replace view v_test2 as select * from test2
where id>10 with read only
5.内嵌式视图(把子查询放在from里面)
内嵌式视图不属于任何用户,也不是对象。
前n行查询分析:rownum,与子查询语句联合使用.
select rownum,id from(select id from test order by id asc) where rownum<4;
(rownum是一个伪劣,不是真实的列)