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 视图名
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 视图名