oracle 查询结果当作表名,紧急求助中
答案:2 悬赏:70 手机版
解决时间 2021-02-27 00:31
- 提问者网友:火车头
- 2021-02-26 21:30
oracle 查询结果当作表名,紧急求助中
最佳答案
- 五星知识达人网友:傲气稳了全场
- 2021-02-26 21:58
SQL code
create view res_gpsstatus as
select t1.*
from T1 t1, (select to_char(sysdate, 'Q') q from dual) q1
where q1.q = 1
union all
select t2.*
from T2 t2, (select to_char(sysdate, 'Q') q from dual) q2
where q2.q = 2
union all
select t3.*
from T3 t3, (select to_char(sysdate, 'Q') q from dual) q3
where q3.q = 3
union all
select t4.*
from T4 t4, (select to_char(sysdate, 'Q') q from dual) q4
where q4.q = 4
create view res_gpsstatus as
select t1.*
from T1 t1, (select to_char(sysdate, 'Q') q from dual) q1
where q1.q = 1
union all
select t2.*
from T2 t2, (select to_char(sysdate, 'Q') q from dual) q2
where q2.q = 2
union all
select t3.*
from T3 t3, (select to_char(sysdate, 'Q') q from dual) q3
where q3.q = 3
union all
select t4.*
from T4 t4, (select to_char(sysdate, 'Q') q from dual) q4
where q4.q = 4
全部回答
- 1楼网友:撞了怀
- 2021-02-26 22:55
提示了什么错误 。
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯