select a.date_time, a.code, a.number, b.number
From a, b
WHERE a.date_time = b.date_time(+)
From a, b
WHERE a.date_time = b.date_time(+)
解决方案 »
- oracle执行外部的sql文件???
- 关于Oracle语句优化的问题
- ORACLE 如何获取当前时间的上一天的日期?
- oracle中能否监视对个别字段的操作
- 未找到预期from关键字?? case语句的问题
- 高分求查询语句,具体如下
- 请问,如何让Oracle在筛选起始条数到终止条数时,先排序在筛选。
- pro c相关的一些简单问题
- 分段查询的sql语句怎样写?
- sql 当我policyno这个字段为空时,把LEVEL1COMDESC这个字段赋值为‘总计’
- 从一个long字段中取数据插入另外一张表的long字段中,报期望的是num类型,返回的是long类型错误,谁能告诉我怎么回事
- 触发器/函数不能读的错误
FROM a
UNION
SELECT date_time,'null' AS code, 0 AS NUMBERa,b.NUMBERb
FROM b
select a.date_time, a.code, a.number, b.number
From a full outer join b
WHERE a.date_time = b.date_time
date_time code number
20041201 420101 12
20041202 420102 122
20041202 420101 12
20041202 420101 121
B
date_time number
20041202 18
20041203 19这该得到什么结果集呢?
我觉得你要求没说清楚
FROM a,b
where a.DATETIM=b.DATETIM(+)
UNION
SELECT distinct b.datetim,'null' AS cod, '0' AS NUMBERa,b.NUMBE AS NUMBERb
FROM b,a
where b.DATETIM not in
(select distinct datetim from a)
From a full join b on a.date_time = b.date_time;
要在9i以上运行才可通过.
select
unique
p.*
from
(select A.date_time,a.code,a.number,b.number from a,b where a.date_time=b.date_time(+)
union
select b.date_time,null code,null a.number,b.number from b) p
select
unique
p.*
from
(select A.date_time,a.code,a.number,b.number from a,b where a.date_time=b.date_time(+)
union
select b.date_time,null code,null a.number,b.number from a,b wherea.date_time<>b.date_time) p