create or replace view v_r_point_zhen as
select '智胜' as name,
2.3 as x_value,
3 as y_value,
80 as point_size
from dual
union all
select '中国区酒柜' as name,
2.6 as x_value,
4.1 as y_value,
70 as point_size
from dual;
这一段代码啥意思啊
------解决方案--------------------
创建或更改 视图v_r_point_zhen,其中含有4个字段name,x_value, y_value,point_size,此视图中现只有二行值
建完后可以直接从视图中取数据,方便些select * from v_r_point_zhen
------解决方案--------------------
union all 将两个select结果集联合起来,视图对应的就是这个结果集