您当前的位置: 首页 > 学无止境 > 心得笔记 网站首页心得笔记
oracle-视图
发布时间:2017-11-23 15:11:21编辑:雪饮阅读()
为scott用户授权可以创建视图的权限:
SQL> conn sys/manager as sysdba
Connected.
SQL> grant create view to scott;
Grant succeeded.
创建视图
SQL> create view newgoods as select * from goods;
View created.
SQL> select * from newgoods;
GOODS_ID CAT_ID GOODS_NAME
---------- ---------- ------------------------------
20 7 good20
21 7 good21
22 7 good22
23 7 good23
24 7 good24
25 7 good25
26 8 good26
27 8 good27
28 8 good28
29 8 good29
30 8 good30
GOODS_ID CAT_ID GOODS_NAME
---------- ---------- ------------------------------
31 8 good31
32 8 good32
33 8 good33
34 8 good34
35 8 good35
36 8 good36
37 8 good37
38 8 good38
39 8 good39
20 rows selected.
删除视图
SQL> drop view newgoods;
View dropped.
关键字词:oracle,视图