view
1、创建视图create view view_name as select ....from ... where...(常用create or replace代替create)
2、删除 drop view view_name
好处:把常用的数据项集中起来不用每次都写一大串sql语句
view
1、创建视图create view view_name as select ....from ... where...(常用create or replace代替create)
2、删除 drop view view_name
好处:把常用的数据项集中起来不用每次都写一大串sql语句