Oracle 创建视图和删除视图

1.创建：

create or REPLACE view p_rate
AS
select r.userid,r.rateset,p.usercode,p.username,p.alipayid 
from rate r,pro_user p where r.userid=p.userid;

2.删除：

drop view 视图名